Avatar of Frank .S
Frank .S
Flag 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


ifstatement not calculating correctly - 1
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Frank .S

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Kesavan Jeganarayanan

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)


Frank .S

ASKER
hi kesavan, your formula does not work for me... please recheck
Your help has saved me hundreds of hours of internet surfing.
fblack61