if then formula
 

i'm guessing it's a if then. i'm trying to calculate the BMI (body mass
index).
i have 2 "inches" fields and 2 "weight" fields.
i want to calculate whichever is populated into a different formula.

so if
a1=0 b1=4
a2=4 b2=5
but i want to use either a1 or a2 (whichever is populated) and b1 or b2
(whichever is populated).

so (a1*703)/(b1*b1) is what i'm looking for essentially. hopefully this
makes sense.
tia

if then formula
 

Hi Ann,
You could use the MAX function.
MAX(A1,B1) will give you just the populated cell
MAX(A2,B2)

Don't quite understand what you want to do with these.
your line "so (a1*703)/(b1*b1) is what i'm looking for essentially" confused
me. Not sure where the 703 came from, or am I just a bit thick tonight?
Anyhoo,
If you want to multiply them together, for example:
=MAX(A1,B1)*MAX(A2,B2)
Regards - Dave.

if then formula
 

yes, that did it, thanks! 703 is a multiplication factor in calculating BMI.

"Dave" wrote:

Hi Ann,
You could use the MAX function.
MAX(A1,B1) will give you just the populated cell
MAX(A2,B2)

Don't quite understand what you want to do with these.
your line "so (a1*703)/(b1*b1) is what i'm looking for essentially" confused
me. Not sure where the 703 came from, or am I just a bit thick tonight?
Anyhoo,
If you want to multiply them together, for example:
=MAX(A1,B1)*MAX(A2,B2)
Regards - Dave.

if then formula
 

Glad to help.
Thanks for the feedback
Dave.