Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 137
Default 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!!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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!!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 80
Default 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!!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I show what the percentage is of one figure to another? JR Hove Excel Worksheet Functions 7 February 1st 08 06:35 PM
Adding a figure + a percentage after using lesser than or greater stevemel50 Excel Discussion (Misc queries) 2 January 10th 07 07:26 PM
Need formula to figure out percentage of change for 5 years klhering Excel Discussion (Misc queries) 3 July 26th 06 03:30 PM
Need to figure out a percentage [email protected] Excel Discussion (Misc queries) 3 April 26th 06 08:54 PM
Percentage difference calc that knows the largest figure Mighty Magpie Excel Discussion (Misc queries) 3 November 10th 05 06:45 PM


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"