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...
Another approach that should work on legacy code is
= LOOKUP(AD2, {1;101;301}, {"Small";"Medium";"Large"})
The boundaries have been tweaked because LOOKUP implements ">=100" rather than ">100" as required.
