Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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) |
#4
|
|||
|
|||
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) |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Year equals 1999 then multiply cell by x | Excel Discussion (Misc queries) | |||
multiply the value of a cell | Excel Worksheet Functions | |||
How can I add a percentage sign to a cell with data validation | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions |