if then formula

A

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
 
D

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.
 
Top