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
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
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

ASKER

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