Excel Pro wanted

[Millay]

Hi all.

Anyone better with excel thatn me be able to answer this question.

I have a table like :

55.55 | 25.64 | 89.55
---------------------
21.22 | 85.35 | 99.96

I want to create a new sheet using these numbers as the base and increase them all by a cerntain percent, basicalle this is a pricelist.

Any help would be gratfully apreciated.
Andy

[SMHarman]

Something like below.

In Sheet2 put this equation in the bit before the ! defines an alternate sheet. This example will increase sheet 1 A1 by 5%.

=+Sheet1!A1*0.05

Best practice would be to put the increase percentacge in a separate cell and refer to that

=+Sheet1!A1*Sheet2!A20

where A20 is the percentage increase

=+Sheet1!A1*Sheet2!$A$20

Putting $ on the A and the 20 will ensure that when the equation is copied the A20 stays the same. You can do this with the cursor on the cell reference and pressing F4, or type it.

[andygrif]

I think I'm saying the same as SMH above...but perhaps a slightly simpler method:

Take you base prices, current and put them in your colums.

Make a new column for your percentage increase, and use the name function. The simplest way to do this is to use the name box, which is usually found on the top left of your grid, just above the first cell. Highlight the cell you want to name (your pecentage cell) and then type a name (e.g. increase).

When you drag to expand the increase to other colums, if you don't name the cell, then it moves the next cell along in the same way as your base cell (this isn't making much sense).

Anyway, create a new set of colums for your target prices. The the following in the first of your new price boxes: A2 is your original price, Increase is the name of the box with your percentage increase in.

=sum(A2*Increase)+A2


I've attached a sample which is much easier to do than describe!! You'll need to unzip the xls sheet. HTH

[Millay]

Would love to give you guys some greenies, but I dont seem to have the option hmm strange..

[SMHarman]

Originally Posted by Millay

Would love to give you guys some greenies, but I dont seem to have the option hmm strange..

Its the scales icon on the bottom left of each post between the green light bulb and the hazzard sign.

Happy repping. There is a whole long thread on the subject if you want to get your teeth into the supposed etiquette!

I know you are on post 10, but welcome .

[Millay]

Originally Posted by SMHarman

I know you are on post 10, but welcome .

post 110 ops 112 now lol...

Cheers
Andy