Forum Discussion
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...
Hi Detlef - many thanks, looks v elegant, but using Excel for Mac the O365 version - it returns a #NAME error.. tried repeatedly to jiggle this around - is it a version problem?
Hello,
this one is not as elegant, but it works in all versions of Excel:
=9270*B3/(IF(A3="m",6680,8780)+IF(A3="m",216,244)*C3)