I have data that I want to pull from a table but want to use a formula to
calculate the answer to allow for variance. In normal english the formula I
am trying to use is =If the Max-Average/Average is <1 then take the Average
and add 1/2 of the standard deviation. The formula below provides me with a
"False" answer instead of a number figure.

=IF 'Stats Table'!$C$15<0, IF ('Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1, then 'Stats Table'!$C$15+'Stats
Table!$C16*B15)

Can someone please tell me what I am doing wrong with this formula? Thank
you for your help and happy holidays!

BearsFan