if statement rounddown formula result not calculating correctly
hi experts the following ifstatement in cell J7 is not calculating correctly, please give me a solution
- should = h7*j3 (round down because is a negative qty) therefore -45 x 0.03= 1.35 rounded down to 1.00
Hi Frank
Where is your quantity.
If you define your quantity in E7, and if it is negative, use this formula.
=IF(E7<0, ABS(ROUNDDOWN(H7*J3,0)), H7*J3)