formula result incorrect
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
|