We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
Excel tutorial on how to use the IFS function in Excel. Available in versions of Excel 2016 or better, the IFS function works like the IF function in that it returns a value based on criteria you set.
It differs from IF in that IFS doesn’t require a statement if False. Plus, hence the name, it also makes it easier to use multiple IFs.
IFS is available for other functions that use IF, like AVERAGE, COUNT, SUM, etc. In this example, we’re only going to look at IFS.