Remember Me?

#1
Posted to microsoft.public.excel.newusers
 external usenet poster 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
Posted to microsoft.public.excel.newusers
 external usenet poster 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
Posted to microsoft.public.excel.newusers
 external usenet poster 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
 Member 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 04:40 AM [email protected] Excel Worksheet Functions 0 December 10th 05 07:50 PM PBarton Excel Discussion (Misc queries) 2 November 27th 05 10:40 PM Gaurav Excel Worksheet Functions 1 April 15th 05 11:37 PM

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