Making an equation calculator (Ohm's law style)

**wintheronline** · 02-03-2018, 02:53 AM

Hello

I found a video on YouTube of a really neat calculator, but the link in the description is no longer available, so I'm not able to download a copy.
I tried to copy the functions shown in the video but without any luck.
Can anyone tell me what makes this work?
As I see it, you can input any two og four values, and it'll calculate for any of the remainding, but I just can't figure out how.

**JohnTopley** · 02-03-2018, 06:29 AM

See attached

You will need to "Enable Iterative Calculations"

File >>> Options >>>"Enable Iterative Calculations" ..Set to 1

Sample formula

in C2

=IF(ISNUMBER(A2),A2,IF(AND(ISNUMBER(A3),ISNUMBER(A4)),A3*A4,IF(AND(ISNUMBER(A3),ISNUMBER(A5)),A5/A3,"")))