Forum Discussion
#NAME? error with IFS Function
Currently stuck on my course as I am unable to get past this error. '=IFS(AD2>300,”Large”,AD2>100,”Medium”,AD2>0,”Small”)' Is the Function the paper is telling me to use, I can copied this dire...
OldRustyDog The IFS function is available in Excel in Microsoft 365, Office 2021 and Office 2019, and in Excel Online as well.
Which version do you have?
Excel 2016, on work laptop so not my choice
That means you cannot use IFS.
You might use Excel Online (in the browser) for this exercise.
Or if you are allowed to use an alternative, you could use nested IF functions:
=IF(AD2>300,"Large", IF(AD2>100, "Medium", IF(AD2>0, "Small", "")))
Please note that you must use straight quotes around text values, not curly/smart quotes.
