--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cody" wrote in message
...
if(M569="","Unknown",IF(M569<K569,M569+1-K569,M569-K569))

try this.

Cody

"Denise" wrote:

Here is the formula that I am using:

=IF(M569<K569,M569+1-K569,M569-K569)

I want to add:

If K569 is blank then "Unknown"

Thanks for any help.

Denise