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

How do u emulate nesting seven IF functions in a cell?
 

Check the vlookup function. You'd create a table of two columns. The first
column would be 1,2,3,4,5,... The second would be *,2.86,3.01,3.1,3.17,...
If your table is in Sheet2!A:B, the dof is in A2, then the function would be
=vlookup(a2,Sheet!A:B,2,false)
--Bruce

"Arpee Ong" wrote:

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

How do u emulate nesting seven IF functions in a cell?
 

Hi

=CHOOSE(Y6,1,2.86,3.01,3.1,3.17,3.22,3.27,3.3,.... )



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Arpee Ong" <Arpee wrote in message
...
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