Thread: if then formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default 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