Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exclude random words
If you are saying you could treat random words in the same way is if N4
equalled (say) LEFT then in reality all you are checking for is whether N4 contains text or numbers so does this work:- =IF(ISTEXT(N4),"Do this for text","Do this for a number") Mike "Hendrik" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exclude random words
Hi Hendrik,
If you put this in B1 =IF(ISTEXT(A1),0,A1) It will return 0 if A1 is text otherwise the numeric value of A1 Is that what you are trying to do? HTH Martin "Hendrik" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exclude random words
Thanks Mike, this solves my problem!! Must appriciated.
"Mike H" wrote: If you are saying you could treat random words in the same way is if N4 equalled (say) LEFT then in reality all you are checking for is whether N4 contains text or numbers so does this work:- =IF(ISTEXT(N4),"Do this for text","Do this for a number") Mike "Hendrik" wrote: 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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exclude random words
If all the numbers are positive numbers..........
=MAX(A1,0) Vaya con Dios, Chuck, CABGx3 "Hendrik" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |