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?
Other proposal would be:
=9270*B3/IF(A3="m",(6680+216*C3),(8780+244*C3))
also works perfectly - many thanks
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)
yup, that's the Badger! does the job. Many thanks to you and all who suggested solutions.
BariDoc,
probably. SWITCH() was introduced with version 1601 Build 6568.2025.
