Formula, Help needed

[themax16]

--------------------------------------------------------------------------------

I am trying to set up a formula that will add up multiple cells and then create an average. I have no trouble with this atall .... but after generating the average i wanted it to go on and display 'yes' if between -6 and 6. and 'no' if it is out of this region.
This was my first attempt but this always displays 'Yes' as its always either above -6 or below 6.
=IF((((C3+E3)/2)<=6)*OR(((C3+E3)/2)>=(0-6)),"Yes","No")

Can anyone offer any help?

[olasa]

This is what I would do:
=IF(ABS(AVERAGE(C3,E3))<=6,"Yes","No")

Hope it helped
Ola Sandström


Note:
ABS(negative number)-->positive number
ABS(positive number)-->positive number

[themax16]

This formula does not seem to work, always gives no regardless of the value in the cells. is it possible to state between -6 and 6?

[Vasant Nanavati]

=IF(AND((C3+E3)/2>=-6,(C3+E3)/2<=6),"Yes","No")

--

Vasant


"themax16" <[email protected]> wrote in message
news:[email protected]...
>
> --------------------------------------------------------------------------
------
>
> I am trying to set up a formula that will add up multiple cells and
> then create an average. I have no trouble with this atall .... but
> after generating the average i wanted it to go on and display 'yes' if
> between -6 and 6. and 'no' if it is out of this region.
> This was my first attempt but this always displays 'Yes' as its always
> either above -6 or below 6.
> =IF((((C3+E3)/2)<=6)*OR(((C3+E3)/2)>=(0-6)),"Yes","No")
>
> Can anyone offer any help?
>
>
> --
> themax16
> ------------------------------------------------------------------------
> themax16's Profile:
http://www.excelforum.com/member.php...o&userid=23622
> View this thread: http://www.excelforum.com/showthread...hreadid=372948
>

[Bob Phillips]

other offerings in excel.misc

--

HTH

RP
(remove nothere from the email address if mailing direct)


"themax16" <[email protected]> wrote in message
news:[email protected]...
>
> --------------------------------------------------------------------------
------
>
> I am trying to set up a formula that will add up multiple cells and
> then create an average. I have no trouble with this atall .... but
> after generating the average i wanted it to go on and display 'yes' if
> between -6 and 6. and 'no' if it is out of this region.
> This was my first attempt but this always displays 'Yes' as its always
> either above -6 or below 6.
> =IF((((C3+E3)/2)<=6)*OR(((C3+E3)/2)>=(0-6)),"Yes","No")
>
> Can anyone offer any help?
>
>
> --
> themax16
> ------------------------------------------------------------------------
> themax16's Profile:
http://www.excelforum.com/member.php...o&userid=23622
> View this thread: http://www.excelforum.com/showthread...hreadid=372948
>