Percent Salary Increase Over Three Years

Andrew,

In column c write: =1.045 * B

Fill down and Fill Across.

Jerry

If I read (and understood the question) you want to provide a raise to employees where the raise (over 3 years) is 4.5%:

Here is my suggestons:

I added a new table (I called it "Setup"). This table contains information that applies to all cells of the Salary table.

I made the first row of the "Salary" table a header row and the first two columns are header columns.

D3=C3*(1+Setup :: $B$1/100)

select D3 and fill to the right as needed (I stopped in the 2011-2012) column

select D3 thru F3, then fill down as needed

Now add a formula to the 2nd header column to confirm the "3 year raise amount":

B3=(F3-C3)/C3

format B3 as a "%" using the toolbar button

select B3 and fill down as needed.

I think it was to be a 4.5% increase each year, as Jerry did.

But if one wnted to determine an annual increase % given only the 3-year increase %, it can be done with math

X0 = initial pay (known)

X3 = pay at three years

Y3 = 3yr increase % (known)

Y1 = annual increase % (this is what we would want to know)

X3 = X0 * (1+ Y3)

X3 = X0 * (1+ Y1)^3

Put those together to get (1+Y3) = (1+Y1)^3

Rearrange to get Y1 = (1+Y3)^1/3 -1

Then use this value like Jerry did (after adding the 1 back to it).

Apple provides a free, downloadable Users' Guide here:

http://support.apple.com/manuals/#productivitysoftware

Andrew Halatyn wrote:

Thanks to everyone that posted a response. I am wondering, would any of you have a good suggestion for a book or text that would better explain how to set up formulas in Numbers other than the Apple Numbers manual? Or maybe a good tutorial? I'll start researching, but if you have any suggestions, I would really appreciate it. Thanks again!

If you have an idea for a project, think about how you would approach it without a computer. Then write an expression that incorporates your manual approach. The function browser is your best resource for quick references. If you get stuck, the discussions are always here.

Jerry