Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort and exclude certain words | Excel Discussion (Misc queries) | |||
how do I create random blocks of letter and words in excel? | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) | |||
random order in a set of words in 1 column | Excel Discussion (Misc queries) |