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...
Detlef_Lewin
Oct 01, 2017Silver Contributor
BariDoc,
one of many ways:
=9270*B3/(SWITCH(A3,"m",6680,"f",8780,0)+SWITCH(A3,"m",216,"f",244,0)*C3)