I have a function that uses 20*LOG10(1/(1+Rs*1/Z )
I keep getting a “NAME” error for the LOG!) function. There are no problems with any other parts of the 1//z which is a very long
=20*LOG10(1/(1+$F$30*SQRT((((-C30*$D$30*(1-C30^2*$D$30*($E$30-$D$22)))*(C30^2*$D$30^2)+(C30*$D$30*$G$30*(1-C30^2*$D$30*($E$30-$D$22)))*((1-C30^2*$D$30*$E$30)*($G$30*(1-C30^2*$D$30*$E$30)-2*C30^2*$D$30*$D$22*$G$30)))^2+ ((-C30*$D$30*(1-C30^2*$D$30*($E$30-$D$22)))*(C30*$D$30*$G$30*(1-C30^2*$D$30*($E$30-$D$22)))+((1-C30^2*$D$30*$E$30)*($G$30*(1-C30^2*$D$30*$E$30)-2*C30^2*$D$30*$4$22*$G$30))*(C30^2*$D$30^2))^2)/ ((-(C30*$D$30*$G$30*(1-C30^2*$D$30*($E$30-$D$22)))^2)-(C30^2*$D$30^2)^2))))
this is the function display on the calc
Edit (keme): added code markup to display formulas properly