software

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

=IF(Y6=1,quot;*quot;,(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

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

quot;Arpee Ongquot; wrote:

gt; Im using exel for statistical analysis, and i wish to assign the quot;error
gt; degree freedomquot; to its corresponding equivalent. like this one:
gt;
gt; =IF(Y6=1,quot;*quot;,(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)))))))))))))))
gt;
gt; the problem is i have 20 treatments, and i cannot add another nested
gt; functions, anyone can suggest a better function call to emulate this one?
gt; with of course 20 nested IF's

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.laanemetslt;atgt;tarkon.ee )
quot;Arpee Ongquot; lt;Arpee gt; wrote in message
news
gt; Im using exel for statistical analysis, and i wish to assign the quot;error
gt; degree freedomquot; to its corresponding equivalent. like this one:
gt;
gt; =IF(Y6=1,quot;*quot;,(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)))))))))))))))
gt;
gt; the problem is i have 20 treatments, and i cannot add another nested
gt; functions, anyone can suggest a better function call to emulate this one?
gt; with of course 20 nested IF's