if then formula

[Ann]

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

 

[Dave]

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.

 

[Ann]

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

 

[Dave]

Glad to help.
Thanks for the feedback
Dave.