Excel If function alternative
hello
In my spreadsheet, I've been using a nested if function, but now I need to
expand it to 12 if statements and since there is a max of 8, basically my
formula is this
If a1=1, z1, if a1=2, z2, if a1=3, z3 and so on. What other function can I
use to do this
|