View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default Add a percentage to a number

Allen, here is one way, with 500 in A1 format cell B1 as percent then put in
10 in C1 put =A1*B1+A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Allen" wrote in message
...
Greetings,

I have searched the Forum and have not found the answer. If you know the
link post it and I will look there.

I want to take the number 500 in one column and & place a Percentage like
10% in the next column and it add the two columns with a result of 550 in

the
third column.

This is the only function I need, I don't need a total at the end of the
page or anything like that.

Thanks for the help