Remember Me?

#1
May 22nd 05, 06:22 PM
 themax16 Posts: n/a
Formula, Help needed

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

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

#2
May 22nd 05, 06:32 PM
 Vasant Nanavati Posts: n/a

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

--

Vasant

"themax16" wrote in message
...

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

------

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

#3
May 22nd 05, 06:55 PM
 Bob Phillips Posts: n/a

other offerings in excel.misc

--

HTH

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

"themax16" wrote in message
...

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

------

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post taxmom Excel Worksheet Functions 3 March 2nd 05 03:35 PM brantty Excel Worksheet Functions 0 February 25th 05 10:11 AM Edgar Thoemmes Excel Worksheet Functions 3 January 13th 05 02:07 PM Damian Excel Worksheet Functions 1 January 7th 05 04:16 AM o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM

All times are GMT +1. The time now is 11:14 AM.