Log10 function problem

[pamam]

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

[EarnestAl]

I assume this is for calc so please delete the tags for the other parts of LibreOffice that don’t use the function. Cheers, Al

[pamam]

I could not retag the tags area. Every time I tried it reverted back after editing it then hitting save, all six tags came back. Either this software does not ork well on FireFox, or Edge or I’m an idiot after 20+ years of software development.

[Ratslinger]

I dun know - tags worked OK for me.

[anon73440385]

I could not retag the tags area.

Type ENTER twice after having modified the tags field (and you are right with this software does not ork well at this point [and others])

[keme]

About three quarters into your formula you have an invalid reference to cell $4$22:

=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))))

[mikekaganski]