Frank .S

asked on

# if statement rounddown formula result not calculating correctly

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

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

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)