Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Reply To: Excel IFS()

#75032
Richard
Guest

SWITCH is a similar function that was added last year. The first parameter is the expression to evaluate. If it equals the second parameter, the third is returned. If it equals the fourth parameter, the fifth is returned and so it continues in pairs. The final parameter is the default if there were no other matches. In Tom’s example it could work like this:

If cell C11 equals 1, return cell B9 but…
If cell C11 equals 2, return cell B10 otherwise…
Return the text “None”

Which you’d enter as:

=SWITCH(C11,1,B9,2,B10,”None”)