Price List Help

  • Thread starter Thread starter OhMarty
  • Start date Start date
O

OhMarty

I have a price list formula that calculates from basic fixed amounts in certain columns and rows. Is there anyway to change all the fixed amounts at once. I want to increase the basic amounts all by 3%. Can this be done or do I have to calculate each cell manually?Thanks so much.
 
Hi Marty!

Put 1.03 in a cell
Copy
Select the data to be uplifted
Edit > Paste Special > Multiply
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
I have a price list formula that calculates from basic fixed amounts
in certain columns and rows. Is there anyway to change all the fixed
amounts at once. I want to increase the basic amounts all by 3%. Can
this be done or do I have to calculate each cell manually?Thanks so
much.
 
Hi

Type 1.03 in a blank cell. Copy this and then select your range and Paste / Special / Multiply.

Andy.
I have a price list formula that calculates from basic fixed amounts in certain columns and rows. Is there anyway to change all the fixed amounts at once. I want to increase the basic amounts all by 3%. Can this be done or do I have to calculate each cell manually?Thanks so much.
 
Personally I hate to lose info, and by changing the data this way, you will lose the original values. However, put 1.03 in a cell, copy the cell, select all your data and do Edit / paste Special / Multiply.
 
Enter .03 (or perhaps 1.03, depending on how your data is set up) in an
empty cell and copy it. Select your data that you want to
increase>Edit>Paste Special>Multiply>OK

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
I have a price list formula that calculates from basic fixed amounts in
certain columns and rows. Is there anyway to change all the fixed amounts at
once. I want to increase the basic amounts all by 3%. Can this be done or do
I have to calculate each cell manually?Thanks so much.
 
Thanks everyone for your great help!

=(B30-1000)/1000*E2+D2

How can I make this formula render a minimum display of $20.00 if the actual calculation is $10.46
 
OhMarty said:
Thanks everyone for your great help!

=(B30-1000)/1000*E2+D2

How can I make this formula render a minimum display of $20.00 if the
Click to expand...
actual calculation is $10.46

Try this:
=MAX(((B30-1000)/1000*E2+D2),20)
 
Back
Top