Compare with average

[texasalynn]

I'm so deep in the forest I can't see the trees! Help me please.

I am trying to compare each month to the years average and see if it is within 10%+/-

I have this:
=IF(B5=10%>AVERAGE(B5:U5)<10%,"YES","NO")

but that's not getting it!!!! What am I doing wrong? Or I'm completely offbase?

Thanks . . .
texasalynn

 

[Aladin Akyurek]

Maybe:

=IF(ABS(B5-AVERAGE(B5:U5))<10%,"Yes","No")

assuming that the numbers in B5:U5 are in %.

 

[texasalynn]

Maybe this will help explain it better

Book7
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
3	SORT_CODE	Jan-02	Feb-02	Mar-02	Apr-02	May-02	Jun-02	Jul-02	Aug-02	GrandTotal	Jan-02	Feb-02	Mar-02	Apr-02	May-02	Jun-02	Jul-02	Aug-02
4	376					3,180.00	795.00	795.00	795.00	5,565.00	NO	NO	NO	NO	NO	NO	NO	NO
5	523	1,056.58	1,018.23	974.53	504.23	1,445.61	845.73			5,844.91	NO	NO	NO	NO	NO	NO	NO	NO
6	532	818.06	818.06	818.06	818.06	818.06	818.06	818.06	818.06	6,544.48	NO	NO	NO	NO	NO	NO	NO	NO
7	533	995.91	1,114.32	1,443.74	1,182.25	1,538.09	1,276.63	1,295.95		8,846.89	NO	NO	NO	NO	NO	NO	NO	NO
8
Sheet1

Thanks . .
texasalynn

 

[matts]

Just a thought, does this work?

=IF(B5=AVERAGE(B5:I5)<>10%,"YES","NO")

 

[Aladin Akyurek]

The figure shows an OR formula. Why, if it's not correct?

What is the expected result for the value in B4 in the figure? I guess the question is 10% of what?

 

[texasalynn]

Look at G6 - this figure is within the 10%+/- of the average. So I would expect my formula to give "YES" as a result. So my "OR" may be meaningless. I think I need a between.
So if the average for the G6 line is $802.70 the +10% = 882.9689 and the
-10% = 801.60

Does that help?

thanks . . .texaslaynn

 

[Aladin Akyurek]

=IF(AND(B3>=AVERAGE(B3:I3)*(0.9),B3<=AVERAGE(B3:I3)*(1.1)),"Yes","No")

If you compute the average just like you compute the grand total, you can replace the AVERAGE bit in the above formula with the cell where the respective average is computed.

You might also want to replace >= with > and <= with <.