Does this work for you:

=IF(W15="Within Range","",SUM(H4:I39)*W16)
?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Micayla Bergen" wrote in message
...
i have this formula
{=IF(W15="Within Range","",(H4:I39)*W16)}
my range H4:I39 actually equals 101670.50, and W16 is a formula w the
result
of 10%. so the formula result should be 10% of 101670.50, but it returns
303.75, which is about .2%. this has come back across the board and im not
sure why
any help greatly appreciated