| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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). |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage Plus or Minus | Excel Discussion (Misc queries) | |||
| How to change all cells from minus to plus and plus to minus | Excel Worksheet Functions | |||
| Equation for amount minus the percentage. | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
Linear Mode
