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...
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.