View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
turkyildiz turkyildiz is offline
external usenet poster
 
Posts: 7
Default 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