Hi Phil

is this what you're after?

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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,"")