View Single Post
  #1   Report Post  
saborbas
 
Posts: n/a
Default 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