View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
nr nr is offline
external usenet poster
 
Posts: 4
Default 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).