How do I multiply cell value by percentage?
 

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?

How do I multiply cell value by percentage?
 

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?

How do I multiply cell value by percentage?
 

"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?

you can't do this in a single cell, it would be some kind of weird
self-circular reference

just have a column where the client types a cost, and in the next column
along use the formula

A2 = client data, B2 = 1.4*A2

just drag down B2 as far as you have client data

if you're not sure how many client entries there are, you can use

A2=client data, B2 = If(isblank(a2),"",1.4*a2)

and drag down as far as you think you'll definitely need, then whenever a
value is typed into A column, it pops up next to it in B, scaled accordingly
(NB, I assume you used the 1st row for column titles)

How do I multiply cell value by percentage?
 

Thanks!

"Lee Harris" wrote:


"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?

you can't do this in a single cell, it would be some kind of weird
self-circular reference

just have a column where the client types a cost, and in the next column
along use the formula

A2 = client data, B2 = 1.4*A2

just drag down B2 as far as you have client data

if you're not sure how many client entries there are, you can use

A2=client data, B2 = If(isblank(a2),"",1.4*a2)

and drag down as far as you think you'll definitely need, then whenever a
value is typed into A column, it pops up next to it in B, scaled accordingly
(NB, I assume you used the 1st row for column titles)

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?