LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort and exclude certain words jds217 Excel Discussion (Misc queries) 7 April 12th 20 06:33 PM
how do I create random blocks of letter and words in excel? pencean Excel Worksheet Functions 1 January 19th 07 12:08 AM
Non-random numbers generated by excel's data analysis random gener Harlan Grove Excel Discussion (Misc queries) 2 September 13th 05 04:06 PM
GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE Tracker Excel Discussion (Misc queries) 6 August 5th 05 02:49 AM
random order in a set of words in 1 column Beckbeck Excel Discussion (Misc queries) 3 May 27th 05 05:26 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"