It depends on your version of Excel IFS is a new function that came out with some versions of Excel 16 10 did not have it, and it sounds like the version of 16 you have doesn't either However, you can try a LOOKUP instead =LOOKUP (E5, {0,,,}, {0,002,004,006})The #NAME error in Excel occurs when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a textIn the formula of cell
How To Fix Value Error In Your Excel Formulas Youtube