Chitest Help

[Tigerqb12]

My girlfriend needs some help using the Chitest function in excel. She's not very familiar with excel, so she came to me, but I'm not that great with functions that I dont know how to mathematically do myself. So, she has data with an actual range of 47 positive, 42 negative, and 26 neutral. Her expected values were 57.5 positive, 57.5 negative, and 0 neutrals. Now, I found a chitest calculater online, and this gave us a number with these values. However, I can only get an error in excel. I'm guessing its a syntax thing, but I'm not sure. Anyhelp would be a huge help!

 

[agihcam]

Book1
	A	B	C	D
6	actual
7	positive	47
8	neutral
9	negative	42
10
11
12	expected
13	positive	57.5
14	neutral
15	negative	57.5
16
17		0.047461991
Sheet1

zero ( 0 ) should be blank.