AND/OR Formula
 

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,"")

AND/OR Formula
 

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,"")

AND/OR Formula
 

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,"")