Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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,"") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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,"") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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,"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |