View Single Post
  #5   Report Post  
Kelly P.
 
Posts: n/a
Default How do I multiply cell value by percentage?

Thank you!

"Anne Troy" wrote:

Three columns: Cost, Markup %, Price
In the 3rd column (assuming A, B, and C columns, beginning with row 2):
=A2*(1+B2)
************
Anne Troy
www.OfficeArticles.com

"Kelly P." <Kelly wrote in message
...
I am creating a worksheet to be filled out by a client. I am trying to get
the cell to update cost typed by 40%. For example when the client types
$500
(or whatever number) in the cell it needs to automatically update the
amount
by 40%. Any suggestions?