Help with Ifs Formula

[rtryan]

I am not very good at Excel and need your help with a formula(s). Place formula in Column D, I'm looking to add 1 to Column A if Column C is equal to 3 but not greater than 3 Column A, if the number in Column C is equal to but not greater than 6 then add 2 to Column A, if the number in Column C is equal to but not greater than 9 then add 3 to Column A, if the number in Column C is equal to but not greater than 12 then add 3 to Column A. Finally, in the same formula, if the Column C is equal to and greater than -3, subtract 1 from Column A.

 

[awoohaw]

if equal to # but not greater than #

means Less Than or Equal to, try this. If not please explain what that phrase means.

Mr Excel Questions 71.xlsm
	A	B	C	D
1	Pts Req	Pts Pull	+or-
2	31	36	5	33
3	9	20	11	12
4	30	36	6	32
5	37	47	10	40
6	19	26	7	22
7	29	27	-2	30
Sheet5

Cell Formulas
Range	Formula
D2:D7	D2	=IF(C2<-3,"",IF(C2<=3,1,IF(C2<=6,2,IF(C2<=12,3,IF(C2>=-3,-1,0))))+A2)

 

[rtryan]

Thank you. However, cells C6 and C7 were negative numbers and the formula didn't return the correct responses in D6 and D7. If the number is equal to or greater than -3 or more (-4, -5, -6, etc), I need it to subtract 1 from Column A (A6 and A7).

 

[awoohaw]

I'm sorry. I'm not sure if english is your primary language or not. But (-4,-5,-6, etc) are LESS THAN -3.
Here is a number line:

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
3	Numbers to the left are less than numbers to the right
4	_	_	_	_	_	_	_	_	_	_	_	_	_	_
5	-6	-5	-4	-3	-2	-1	0	1	2	3	4	5	6	7
Sheet1

Please answer my question about what you mean by

if equal to # but not greater than #

Look at this:

Mr Excel Questions 71.xlsm
	A	B	C	D	E	F	G
1	Pts Req	Pts Pull	+or-			Your Matrix of adding to Column A:
2	31	36	5	33
3	9	20	11	12		<= -3	-1
4	30	36	6	32		<= 3	1
5	37	47	10	40		<= 6	2
6	19	26	7	22		<= 12	3
7	29	27	-2	30		>12	????
8	29	22	-7	28
9	21	20	-1	22
10	37	31	4	39
rtryan

Cell Formulas
Range	Formula
D2:D10	D2	=IF(C2<=-3,-1,IF(C2<=3,1,IF(C2<=6,2,IF(C2<12,3,0))))+A2