(This is just a curiosity, possibly a warning, only loosely related to bioinformatics)
I accidentally found that according to Excel the number 1.0E-310 *is not* smaller than 0.05 (at least, on my Windows XP, 32 bit, Excel 2007).
Try the following in Excel:
All the best
Dario
I accidentally found that according to Excel the number 1.0E-310 *is not* smaller than 0.05 (at least, on my Windows XP, 32 bit, Excel 2007).
Try the following in Excel:
Code:
1.0E-305 "=A1<0.05" Gives TRUE 1.0E-310 "=A2<0.05" Gives FALSE! 1.0E-310 "=A3>0.05" Gives TRUE!
Dario
Comment