Maybe:

=IF(OR(AND(M$4=$E6,M$4<$F6),AND(M$4=1,M$4<=7)),$ B6,"")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Phil Hageman" wrote in message
...
I want to add an OR to this formula: if $M4 is a number 1-7, "true"
results,
and $B6 appears.

=IF(AND(M$4=$E6,M$4<$F6),$B6,"")