Hello I am Trying to use a formula in my sheet.
In a non excel format it would look like this
BMR = 655 + (9.6 x weight in kg) + (1.8 x height in cm) – (4.7 x age in Yrs)
My attempt in excel looks like this
=655+(9.6*C7)+(1.8*C6)-(4.7*C5)
1. Is this the correct way to get the answer I am looking for.
2. When nothing is inputted C5-C7 I get returned 655. I can see why but I would rather have a blank cell.
Can someone rearrange the formula for me so it works please?
Regards
Bookmarks