ExcelBanter - IF OR RANGE CONDITIONING

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF OR RANGE CONDITIONING (https://www.excelbanter.com/excel-discussion-misc-queries/138959-if-range-conditioning.html)

turkyildiz

IF OR RANGE CONDITIONING

If I use

=IF(OR(B21240,D21118,C2196),"NO YOU ARE OK","FOR SURE")

it does it for one row if I use

=IF(OR(B21:B43240,D21:D43118,C21:C4396,E21:E43 4000),"FOR SURE","NO
YOU ARE OK")

does not do anything at all, any advise to get this formula to react
if i typle 244 in column b32 to turn to for sure

Regards

JE McGimpsey

IF OR RANGE CONDITIONING

One way:

=IF(COUNTIF(B21:B43,"240") + COUNTIF(C21:C43,"96") +
COUNTIF(D21:D43,"118") + COUNTIF(E21:E43,"4000"), "FOR SURE","NO YOU
ARE OK")

In article .com,
"turkyildiz" wrote:

If I use

=IF(OR(B21240,D21118,C2196),"NO YOU ARE OK","FOR SURE")

it does it for one row if I use

=IF(OR(B21:B43240,D21:D43118,C21:C4396,E21:E43 4000),"FOR SURE","NO
YOU ARE OK")

does not do anything at all, any advise to get this formula to react
if i typle 244 in column b32 to turn to for sure

Regards

All times are GMT +1. The time now is 07:37 PM.