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!