| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is it possible to count if within a number region?
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=372947 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i count the number of conditional formatted cells? | Excel Discussion (Misc queries) | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| Count the number of worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Threaded Mode
