Every IF statement needs a true result & a false result. You need to close
off the false results for you IF statements. e.g.,

=if(a11,true,false)

'Nested example
=if(a11,if(a22,true,false),false)
--
http://HelpExcel.com




"bearsfan" wrote:

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