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!

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!

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!

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!

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!