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)
|