Calculation help

[5835]

Hi guys,
I need some help with calculations. heres the scenario:
BMI = (weight in kg)/ (height in meters)squared
i have a these fields : BMI, Height(in inches) and Weight( in lbs).
to calculate weight in kg, you take the weight and divide by 2.2
to calculate the height in meters, you take the hieght and divide by 39.37
This is what i tried but it did not work:
Round((WEIGHT / 2.2) / ((HEIGHT / 39.37) *(HEIGHT / 39.37)))

thanks

 

[Schlogg]

How did it not work? If you used exactly that expression, it should have given you an error message. Try -
Round((WEIGHT / 2.2) / ((HEIGHT / 39.37) *(HEIGHT / 39.37)), 2)


Cheers,
Paul J.

 

[5835]

Thanks Paul! it worked great
one question though, what was the last "2" for?

 

[Schlogg]

Sorry for the delay. I've been a bit busy.
Look at this -
Round (MessyCalulation, 2)
It rounds the result to 2 decimal places.

Cheers,
Paul J.

 

[5835]

Thanks a lot Paul,
You are a big help.