ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Add a percentage (https://www.excelbanter.com/excel-discussion-misc-queries/170079-add-percentage.html)

slavenp

Add a percentage
 
I'm new to excel and working on 2007. This I know will be an easy one for
someone out there. I have the figure 36977 and want to add 8% to it via a
forumla.

I've had a look about, but everything seems a tade more complex than what
I'm looking for.

Hope you can help, thanks.

Stephen[_2_]

Add a percentage
 
If the number is in A1, use the formula
=A1*1.08

"slavenp" wrote in message
...
I'm new to excel and working on 2007. This I know will be an easy one for
someone out there. I have the figure 36977 and want to add 8% to it via a
forumla.

I've had a look about, but everything seems a tade more complex than what
I'm looking for.

Hope you can help, thanks.




Dave F[_2_]

Add a percentage
 
=36977 * 1.08

Generally if you want to increase a number by a certain percentage
multiply that number by the sum of 1 plus the percentage. The
asterisk, * , is the symbol Excel uses for multiplication.

Dave

On Dec 18, 6:31 am, slavenp wrote:
I'm new to excel and working on 2007. This I know will be an easy one for
someone out there. I have the figure 36977 and want to add 8% to it via a
forumla.

I've had a look about, but everything seems a tade more complex than what
I'm looking for.

Hope you can help, thanks.




All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com