16th October 2020 at 09:05
#75032
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”)