This should be easy:

J

Jaytee

I want to use a simple formula for three numbers, but the input numbers are
different parts of the formula. For example, here's a simple formula:

A-B=C

Sometimes I know A and B, Sometiimes I know A and C. Can I set this up so
whatever two i input, the third number calculates?
 
S

SteveW

A2 = A
B2 = B
C2 = C
D2 = IF(ISBLANK(A2),C2+B2,IF(ISBLANK(B2),A2-C2,A2-B2))

Assuming you only have one blank field :)

Steve
 
K

Kassie

In A1: =C1+B1
In B1: =A1-C1
In C1: =A1-B1

You will get a circular reference warning as you enter these formulae, which
you can just X out of. You will end up with 3 "0"'s to start off with. As
you enter the second possible number, the remaining one will calculate.
However, you will wipe out the formulae in the 2 cells where you insert
numbers
 
J

Jaytee

Kassie's method works best for my application, but the "ISBLANK" Function
will help with another project.

I had no idea that you could ignore a circular reference! Cool.

Thanks Guys!
 
Top