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 |
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 |
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 |
All times are GMT +1. The time now is 05:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com