M
Mike Loustalot
I have created an IF formula that is not returning the
correct value into the cell. The value should be zero (0)
but instead it is returning a middle function. Here is
the formula.
=-IF(SUM($C$19*($D$14:K14))<=54677,($C$19*K14),0)
In this case the SUM Function equals 70752, which by my
calculations is less than or equal to 54677, which makes
this statement false, which should return 0. But the
value in the cell is 11088, which is represented by
($C$19*K14).
Any ideas????//
correct value into the cell. The value should be zero (0)
but instead it is returning a middle function. Here is
the formula.
=-IF(SUM($C$19*($D$14:K14))<=54677,($C$19*K14),0)
In this case the SUM Function equals 70752, which by my
calculations is less than or equal to 54677, which makes
this statement false, which should return 0. But the
value in the cell is 11088, which is represented by
($C$19*K14).
Any ideas????//