Remember Me?

#1
December 21st 09, 08:51 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Oct 2006 Posts: 47
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
December 21st 09, 09:10 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 136
find percentage

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
December 21st 09, 09:17 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 303
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
July 7th 21, 11:02 AM
 Member First recorded activity by ExcelBanter: Jun 2021 Posts: 47
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post buzy lizzy Excel Discussion (Misc queries) 4 August 25th 08 08:45 PM Bernard Liengme Excel Worksheet Functions 1 December 12th 05 05:40 AM [email protected] Excel Worksheet Functions 0 December 10th 05 08:50 PM PBarton Excel Discussion (Misc queries) 2 November 27th 05 11:40 PM Gaurav Excel Worksheet Functions 1 April 15th 05 11:37 PM

All times are GMT +1. The time now is 01:52 PM.