formulas not transferring over to new page

[alhollin44]

I have had so much help on this forum before for the exact same issues with an excel book I use to calculate commission. It has been working fine for the last few months but now that I am trying to do January 2015 commission the formulas are somehow not working. I copied the formulas and formats from December 2015 and even though the formulas in the cells appear to be identical my first tear (below 30k in sales) is showing the same as my second tier (over 30k in sales). Please help excel friends

[MarvinP]

Hi al,

After looking at your workbook for a few minutes, a formula refers to cell Q5. You have a number on your Dec 2014 sheet in Q5 but not on the Jan 2015 sheet. Could that be the problem?

[FDibbins]

1st, Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

2nd, check the contents of Q5

[alhollin44]

I tried to copy and paste the same table I have been using for the past year to a new page for 2015 and despite the formulas looking identical they are not calculating correctly.

[AlKey]

The layouts are not identical so there is no reason to expect formulas to work by simply copying.

[alhollin44]

Yes, that definitely has something to do with it however it did not solve the issue. Now everything says NA

[:) Sixthsense :)]

The Q5 cell of January 2015 sheet is blank. Fill a value in it

[alhollin44]

how are they not identical?

[FDibbins]

Yes, that definitely has something to do with it however it did not solve the issue. Now everything says NA

	H	I	J	K	L	M	N	O	P	Q
2
3
4		Discount level:	0%	5%	10%	15%	Totals
5	Sales up to	30,000	19,831.50	-	4,193.20	-	24,024.70			350
6		Commission rate:	5.0%	6.0%	4.5%	4.0%
7		Commission:	991.58	-	188.69	-	1,180.27
8	Sales over	30,000	-	-	-	-	-
9		Commission rate:	8.0%	7.5%	7.0%	6.0%
10		Commission:	-	-	-	-	-
11		Total Sales:	19,831.50	-	4,193.20	-	24,024.70
12		Total Commission	991.58	-	188.69	-	1,180.27

is this what you got?

[FDibbins]

I will merge the 2 threads