| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract a known percentage
Hello,
Assume cell A1 has the % of discount I need to offer. (say 5%) Assume cell A2 has the gross amount before a discount is calculated...(say £100) and I just want the net amount (ie after disccount in cell A1 is applied) to be in cell A3 What should the formula in cell A3 look like (to result in £95) Sure this is easy for many...but its got me beaten. I know I can just put a formula of 0.95*A2. But thats not what I wnat to, as I will need to change the actual value in A1 frequently, and dont want to have to change the foumala each time I make that change. Thank you very much |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract a known percentage
How about this:
=A2-(A2*A1) HTH Elkar "spudsnruf" wrote: Hello, Assume cell A1 has the % of discount I need to offer. (say 5%) Assume cell A2 has the gross amount before a discount is calculated...(say £100) and I just want the net amount (ie after disccount in cell A1 is applied) to be in cell A3 What should the formula in cell A3 look like (to result in £95) Sure this is easy for many...but its got me beaten. I know I can just put a formula of 0.95*A2. But thats not what I wnat to, as I will need to change the actual value in A1 frequently, and dont want to have to change the foumala each time I make that change. Thank you very much |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract a known percentage
With 5% in A1:
=A2*(1-A1) HTH. Best wishes Harald "spudsnruf" wrote in message ... Hello, Assume cell A1 has the % of discount I need to offer. (say 5%) Assume cell A2 has the gross amount before a discount is calculated...(say £100) and I just want the net amount (ie after disccount in cell A1 is applied) to be in cell A3 What should the formula in cell A3 look like (to result in £95) Sure this is easy for many...but its got me beaten. I know I can just put a formula of 0.95*A2. But thats not what I wnat to, as I will need to change the actual value in A1 frequently, and dont want to have to change the foumala each time I make that change. Thank you very much |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtract a known percentage
Thats perfect. Thank you very much.
"Elkar" wrote: How about this: =A2-(A2*A1) HTH Elkar "spudsnruf" wrote: Hello, Assume cell A1 has the % of discount I need to offer. (say 5%) Assume cell A2 has the gross amount before a discount is calculated...(say £100) and I just want the net amount (ie after disccount in cell A1 is applied) to be in cell A3 What should the formula in cell A3 look like (to result in £95) Sure this is easy for many...but its got me beaten. I know I can just put a formula of 0.95*A2. But thats not what I wnat to, as I will need to change the actual value in A1 frequently, and dont want to have to change the foumala each time I make that change. Thank you very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract | Excel Worksheet Functions | |||
| divide a total, subtract one then format as a percentage | Excel Worksheet Functions | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
| Add IF or Subtract IF?? | Excel Worksheet Functions | |||
Linear Mode
