percentage is minus should be plus

[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

 

[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

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

 

[Mike H]

Hi,

I think the answer is 110.91653

=E2-(E2*D2)

Mike

 

[muddan madhu]

may be this one

=E2*(100%-D2)