Find the value of a percentage

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

Hi,

I tried my inquiry once but I did not get a reply. Maybe I was not clear
and explicit with my question, therefor I will try again. Please anyone with
a reply.

I have column "A" 1 thru 200 numbers. I need to create column "B" showing
the total of an increase of 35% (value plus the 35%).

Now I have to create a column "C" with the value or a number that if you
subtract 40% will give me the number in colmn "B".

I hope I made myself clear and comprehesible this time. Please do reply,
anyone.

Thank you
 
Hi,
to apply 35 % in column B enter

=a1*1.35

copy the formula down

in column C enter

=a1/0.6

if this helps please click yes thanks
 
You received several replies yesterday.

Quit waiting for a personal email reply and start searching for your posts
which have the replies.


Gord Dibben MS Excel MVP
 
Back
Top