percentage is minus should be plus
 

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

percentage is minus should be plus
 

On Jan 24, 6:29 am, Wanna Learn
wrote:
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).

percentage is minus should be plus
 

Hi,

I think the answer is 110.91653

=E2-(E2*D2)

Mike

"Wanna Learn" wrote:

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

percentage is minus should be plus
 

may be this one

=E2*(100%-D2)







On Jan 24, 4:29*pm, Wanna Learn
wrote:
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