| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Discount Total
Hi All, Can anyone help me with the following. I have the formula =SUM(D2*(20/100)) which gives me the discount value of cell D2 i.e if D2 = £10 then the SUM = £2 But I want the formula to work out the total minus the sum ie. £10 - 20% = £8 I hope ive made this clear, maybe im just going about it the wrong way. -- mdj101 ------------------------------------------------------------------------ mdj101's Profile: http://www.excelforum.com/member.php...o&userid=33739 View this thread: http://www.excelforum.com/showthread...hreadid=543304 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I find out a total as a percentage using absolute cell | Excel Worksheet Functions | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| show in a excel graphic a total percentage for 5 diff data fiels | Charts and Charting in Excel | |||
| Need to Count number of occurrences and get percentage of total | Excel Worksheet Functions | |||
| a number as a percentage out of a total | Excel Worksheet Functions | |||
Threaded Mode
