View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arpee Ong
 
Posts: n/a
Default How do u emulate nesting seven IF functions in a cell?

Im using exel for statistical analysis, and i wish to assign the "error
degree freedom" to its corresponding equivalent. like this one:

=IF(Y6=1,"*",(IF(Y6=2,2.86,(IF(Y6=3,3.01,(IF(Y6=4, 3.1,(IF(Y6=5,3.17,(IF(Y6=6,3.22,(IF(Y6=7,3.27,(IF( Y6=8,3.3)))))))))))))))

the problem is i have 20 treatments, and i cannot add another nested
functions, anyone can suggest a better function call to emulate this one?
with of course 20 nested IF's