| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I add a formula?
How do I add a formula to find 15% of an amount? The amounts are listed in
column D. I want to see 15% in Column E |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I add a formula?
Hi,
=D1*15% Regards, Jaleel "Lo" wrote: How do I add a formula to find 15% of an amount? The amounts are listed in column D. I want to see 15% in Column E |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I add a formula?
On the off-chance that the 15% is included in the amount, you can use
=A1*(1-1/1.15) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jaleel" wrote in message ... Hi, =D1*15% Regards, Jaleel "Lo" wrote: How do I add a formula to find 15% of an amount? The amounts are listed in column D. I want to see 15% in Column E |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
