Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 47
Default find percentage

Hi helping hand;

I have column"A" with numbers. I am required to add a column "B" showing a
total amount with an addition of 35%.

Now I have to add a column "C" that would give me a number that if you
subtract 40% it will give me the exact number of column "B".

Can anyone help

Thank you
--
smile
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CM CM is offline
external usenet poster
 
Posts: 136
Default find percentage

assuming a1 has your value;

in b1: =A1*1.35
in c1: =B1/0.6


--
hope to help,
cm


"israel" wrote:

Hi helping hand;

I have column"A" with numbers. I am required to add a column "B" showing a
total amount with an addition of 35%.

Now I have to add a column "C" that would give me a number that if you
subtract 40% it will give me the exact number of column "B".

Can anyone help

Thank you
--
smile

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 303
Default find percentage

Hope I 've got you right
B = A*1.35

B = 0.6 *C

C= 2.25 *A

say A =100
B will be 135
C will be 225

Greetings from New Zealand

"israel" wrote in message
...
Hi helping hand;

I have column"A" with numbers. I am required to add a column "B" showing
a
total amount with an addition of 35%.

Now I have to add a column "C" that would give me a number that if you
subtract 40% it will give me the exact number of column "B".

Can anyone help

Thank you
--
smile



  #4   Report Post  
Member
 
Posts: 47
Default Formula

Hello!


You can just format it as:

B1 = A1 * 1.35

C1 = A1* 2.25

That way you can get the numbers you want based on the specs you provided.

For more tips on excel or financial models. Hope this helps.
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
What formula do I use to find a percentage change? buzy lizzy Excel Discussion (Misc queries) 4 August 25th 08 08:45 PM
Find percentage ??? Bernard Liengme Excel Worksheet Functions 1 December 12th 05 04:40 AM
Find percentage ??? [email protected] Excel Worksheet Functions 0 December 10th 05 07:50 PM
How do I find a percentage? PBarton Excel Discussion (Misc queries) 2 November 27th 05 10:40 PM
Find percentage Trend Gaurav Excel Worksheet Functions 1 April 15th 05 11:37 PM


All times are GMT +1. The time now is 11:56 AM.

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

About Us

"It's about Microsoft Excel"