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?
BariDoc,
probably. SWITCH() was introduced with version 1601 Build 6568.2025.