Forum Discussion
BariDoc ESPCOP
Oct 01, 2017Copper Contributor
IF Function to adjust calculations for gender
New to this - please be patient :-) Medical application. Have one of two formulae to use to calculate lean body weight, depending on gender of patient in column A (M or F). there must be a simple an...
CARLOS ADRIAN
Oct 02, 2017Copper Contributor
Other proposal would be:
=9270*B3/IF(A3="m",(6680+216*C3),(8780+244*C3))
BariDoc ESPCOP
Oct 02, 2017Copper Contributor
also works perfectly - many thanks