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)