How do I multiply cell value by percentage?

[Kelly P.]

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?

[Anne Troy]

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 [email protected]> wrote in message
news:[email protected]...
>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?

[Lee Harris]

"Kelly P." <Kelly [email protected]> wrote in message
news:[email protected]...
>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)

[Kelly P.]

Thanks!

"Lee Harris" wrote:

>
> "Kelly P." <Kelly [email protected]> wrote in message
> news:[email protected]...
> >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)
>
>
>

[Kelly P.]

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 [email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>