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
|