View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Formula/function that checks for a set of values.

Hi

The formula I reposted (and I've got in my thread and sent items also) is
=AND(B$4:B$21<"E",B$4:B$21<"D",B$4:B$21<"N")
which is different but I don't know why that didn't appear to you!!

Try it.

Andy.

"Memnok" wrote in message
...

Hi

That's because I left the signs out of it!!

Try this:
=AND(B$4:B$21"E",B$4:B$21"D",B$4:B$21"N")

Sorry!
Andy.



Isn't that the same? Ha-ha! :) I copied and pasted them side my side
and they are identical.

You are a trooper, thanks for your continued effort!


--
Memnok