Can't figure out how to bring back negative numbers using IF function

[kxellis26]

Greetings -

I am building a spreadsheet for an incentive we are running for our team. I am looking to assign point values based on certain KPI performance, with anyone under the goal earning negative .5 points, just outside of goal earning zero and hitting goal earning 1. I have been playing with it for a while and can't seem to find a way to bring back -.5 or (.5) for the bottom performers when calculating total points.

It's kind of confusing...

Incentive Tracker - October.xlsx
	D	E	F	G	H	I	J
3	Adherence	Points	Break	Points	AHT	Points	Total Points
4	-100%		-100.00%		#########	-.5	#VALUE!
5	95%	1	99.94%	1	10:40	-.5	1.50
6	-100%		-100.00%		#########	-.5	#VALUE!
7	-100%		-100.00%		#########	-.5	#VALUE!
8	83%	(.5)	94.00%	1	16:21	1	1.50
9		1		-.5	#########	-.5	0.00
10	95%	1	99.67%	1	11:42	0	2.00
11	-100%		-100.00%		#########	-.5	#VALUE!
12		1		-.5	#########	-.5	0.00
13	91%	1	100.11%	1	15:46	1	3.00
14	-100%		-100.00%		#########	-.5	#VALUE!
15	89%	1	132.78%	-.5	4:10	-.5	0.00
16	94%	1	100.78%	1	21:11	-.5	1.50
17	86%	0	105.67%	0	14:33	0	0.00
18	90%	1	100.33%	1	21:01	-.5	1.50
19	85%	(.5)	102.22%	1	15:55	1	1.50
20	-100%		-100.00%		#########	-.5	#VALUE!
21	90%	1	78.17%	1	14:51	0	2.00
22	80%	(.5)	141.94%	-.5	11:59	0	-1.00
23	81%	(.5)	106.39%	0	13:06	0	-0.50
24	90%	1	100.06%	1	8:04	-.5	1.50
25	76%	(.5)	92.89%	1	23:54	-.5	0.00
26	-100%		-100.00%		#########	-.5	#VALUE!
27	91%	1	99.89%	1	15:08	0	2.00
28	84%	(.5)	144.50%	-.5	17:34	1	0.00
29	-100%		-100.00%		#########	-.5	#VALUE!
30	-100%		-100.00%		#########	-.5	#VALUE!
31	76%	(.5)	100.00%	1	10:34	-.5	0.00
32	86%	0	100.33%	1	1:26	-.5	0.50
33	90%	1	145.89%	-.5	10:02	-.5	0.00
34	73%	(.5)	99.17%	1	20:29	-.5	0.00
35	78%	(.5)	97.50%	1	5:15	-.5	0.00
36	87%	0	100.00%	1	20:10	-.5	0.50
Previous Day

Cell Formulas
Range	Formula
D4:D36	D4	=IFERROR(INDEX(Adherence!E:E,MATCH('Previous Day'!B4,Adherence!C:C,0)),"")
E4:E36	E4	=IF(AND(D4>=0%,D4<=85%),"(.5)",IF(AND(D4>85%,D4<=87%),"0",IF(AND(D4>87%),"1",IF(AND(D4=-100%),"",0))))
F4:F36	F4	=IFERROR(INDEX(Break!I:I,MATCH('Previous Day'!B4,Break!A:A,0)),"")
G4:G36	G4	=IF(AND(F4>=0%,F4<=105%),"1",IF(AND(F4>105%,F4<=110%),"0",IF(AND(F4>110%),"-.5",IF(AND(F4=-100%),"",0))))
H4:H36	H4	=IFERROR(INDEX(AHT!F:F,MATCH('Previous Day'!B4,AHT!D:D,0)),"")
I4:I36	I4	=IF(AND(H4>=0,H4<=0.4583),"-.5",IF(AND(H4>0.459,H4<=0.6458),"0",IF(AND(H4>0.6465,H4<=0.7917),"1",IF(AND(H4>=0.7924),"-.5",IF(AND(H4="#########"),"",0)))))
J4:J36	J4	=SUM(E4*1,G4*1,I4*1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H4:H42	Cell Value	="#########"	text	NO
F4:F42	Cell Value	=-1	text	NO
D4:D42	Cell Value	=-1	text	NO
H4:H42	Cell	contains a blank value	text	NO
H4:H42	Cell Value	between 0.646527777777778 and 0.791666666666667	text	NO
H4:H42	Cell Value	between 0.458333333333333 and 0.645833333333333	text	NO
H4:H42	Cell Value	>0.791666666666667	text	NO
H4:H42	Cell Value	<0.458333333333333	text	NO
F4:F42	Cell	contains a blank value	text	NO
F4:F42	Cell Value	>=1.1001	text	NO
F4:F42	Cell Value	between 1.0501 and 1.1	text	NO
F4:F42	Cell Value	<=1.05	text	NO
D4:D42	Cell	contains a blank value	text	NO
D4:D42	Cell Value	>=0.87	text	NO
D4:D42	Cell Value	between 0.85 and 0.869	text	NO
D4:D42	Cell Value	<=0.85	text	NO
I4:J42	Cell Value	="#########"	text	NO
G4:G42	Cell Value	<0	text	NO
E4:E42	Cell Value	<0	text	NO

 

[kxellis26]

Welp. I figured it out right after I hit send...I'm not sure how to just delete the thread though.