Need Help for a formula

O

OSSIE

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
 
M

mphell0

1. To put them in alphabetical order select the entire range of data
that you
have, go to Data->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.
 
Top