percentage is minus should be plus

W

Wanna Learn

Hello Scenario Discount is in D2, 85.94%, Price is in E2, 788.88 in
F I have the following formula =(E2*D2)-E2 and the answer is -110.81 it
should be 110.81. How do I correct this? Thanks
 
N

nr

Hello Scenario Discount is in D2, 85.94%, Price is in E2, 788.88 in
F I have the following formula =(E2*D2)-E2 and the answer is -110.81 it
should be 110.81. How do I correct this? Thanks
Click to expand...

You should subtract the discount from the price to get the net amount,
which would be E2-(E2*D2).
 
Top