View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hendrik[_2_] Hendrik[_2_] is offline
external usenet poster
 
Posts: 26
Default Exclude random words

Below is the start of my formula:

=IF(OR(N4="Sick?",N4="FW",N4="LEFT",N4="Suspended" ),0, ETC ETC

The problem is, sometimes N4 is populated with a different word than the
above. In that case, I want it to be excluded/handled the same wa as when it
would say FW or LEFT. The problem is, I can't use "greater than 0", cause if
there is a numerical entry in N4, no action is to be taken.

I'm dont know if this is possible or if I'm only dreaming. Thanks for any
input on this!