Link to home
Start Free TrialLog in
Avatar of Frank .S
Frank .SFlag for Australia

asked on

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

User generated image
Avatar of byundt
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

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)

Avatar of Frank .S


hi kesavan, your formula does not work for me... please recheck