ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding a percentage to a figure (https://www.excelbanter.com/excel-worksheet-functions/202231-adding-percentage-figure.html)

newbie

Adding a percentage to a figure
 
I am trying to figure out how to add a percentage to, say column A and have
the figure appear in column B.

i.e. If column A cell 1 has 37 and I want to type a formula adding 40
percent to that and have it appear in column B how is it done???

Thank You!!

Mike H

Adding a percentage to a figure
 
Hi,

=A1*1.4

Mike

"Newbie" wrote:

I am trying to figure out how to add a percentage to, say column A and have
the figure appear in column B.

i.e. If column A cell 1 has 37 and I want to type a formula adding 40
percent to that and have it appear in column B how is it done???

Thank You!!


Meebers

Adding a percentage to a figure
 
One way in b1 enter =a1+(.4*a1)
"Newbie" wrote in message
...
I am trying to figure out how to add a percentage to, say column A and have
the figure appear in column B.

i.e. If column A cell 1 has 37 and I want to type a formula adding 40
percent to that and have it appear in column B how is it done???

Thank You!!





All times are GMT +1. The time now is 01:57 AM.

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