#### piginabush

##### Board Regular

- Joined
- Mar 12, 2010

- Messages
- 55

Column J contains a VLOOKUP Number

Column K contains another VLOOKUP

Column L contains a SUM number, can be positive or negative

Column M contains the following formula;

=IF(L9<-0.5,K9*(ABS(L9)),"0")

Basically, I want to say if L9 is less than 0, return K9 times the absolute of L9, otherwise return 0.

However, the calculation is not coming up right, answers that should be right are not returning correct.

For example, I have L9 = minus 8, K9 = 0.4 and the answer being returned is 3.00 when 8 times 0.4 is 3.20?!?!?

Can anyone shed any light?