Ask Your Question
0

Log10 function problem

asked 2021-01-25 05:58:17 +0200

pamam gravatar image

updated 2021-01-25 08:38:12 +0200

keme gravatar image

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 image description

Edit (keme): added code markup to display formulas properly

edit retag flag offensive close merge delete

Comments

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

Earnest Al gravatar imageEarnest Al ( 2021-01-25 06:10:53 +0200 )edit

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.

pamam gravatar imagepamam ( 2021-01-25 06:41:31 +0200 )edit

I dun know - tags worked OK for me.

Ratslinger gravatar imageRatslinger ( 2021-01-25 07:13:31 +0200 )edit

I could not retag the tags area.

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

Opaque gravatar imageOpaque ( 2021-01-25 11:28:46 +0200 )edit

1 Answer

Sort by » oldest newest most voted
3

answered 2021-01-25 09:17:22 +0200

keme gravatar image

updated 2021-01-25 09:18:01 +0200

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

edit flag offensive delete link more

Comments

1

image description

Mike Kaganski gravatar imageMike Kaganski ( 2021-01-25 10:52:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-01-25 05:58:17 +0200

Seen: 72 times

Last updated: Jan 25