Price List Help

[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.

 

[Norman Harker]

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.

 

[Andy B]

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.

 

[Ken Wright]

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.

 

[Jim]

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.

 

[OhMarty]

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

 

[Paul]

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

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

 

[J.E. McGimpsey]

one way:

=MAX(20,(B30-1000)/1000*E2+D2)

 

[OhMarty]

Fantastic! Thanks! Thanks! Thanks!