I am trying to write a formula to calculate ideal body weight but I am having trouble. I need it to meet the conditions below.
M = 48 kg for the first 152.4 cm + 1.1 kg for each additional cm and - 0.988 kg for each cm under 152.4.
F = 45 kg for the first 152.4 cm + 0.9 kg for each additional cm and - 0.344 kg for each cm under 152.4.
This is what I currently have.
=IF(F5="F",IF(H5>=152.4,(H5-152.4)*0.9+152.4, 152.4-(152.4-H5)*0.344),IF(H5>=152.4,(H5-152.4)*1.1+152.4,152.4-(152.4-H5)*0.988))
Thanks
Bookmarks