software

Hi Can anyone help on this i have a problem first i have a spread sheet
where i have all the company name and i would like to organized them in
alphabetical order, the second problem is that i have another spread
sheet with the amount each person maked and i would like to add to this
sheet a formula to calculate the amount they will make next review,
meaning i have in one cell the amount and next cell i have the
percentage and on the next cell i woul like to have the new amount they
would make with the increase can anyone here give me a hand on this 2
problems i have you help will be greatly appreciated.
Thanks--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: www.excelforum.com/member.php...oamp;userid=31638
View this thread: www.excelforum.com/showthread...hreadid=513300
1. To put them in alphabetical order select the entire range of data
that you
have, go to Data-gt;Sort select the column that your company names
are
in, check ascending and hit OK. Note that if you have a column
heading
you can check header row and then choose your column by the header

row.

2. For the future salary do this:

Assume B2 is current salary, C2 is percent increase put the
following into
D2:

=B2*(1 C2)

copy this formula down for as far as you need to.--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=513300