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

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

This worked.

THANKS!!!!

"Cody" wrote:

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

You're Welcome!

"Denise" wrote:

This worked.

THANKS!!!!

"Cody" wrote:

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

--

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

Just for fun

=IF(M569="","Unknown",M569-K569+(M569<K569))

--

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

=IF(ISBLANK(K569),"Unknown",IF(M569<K569,M569+1-K569,M569-K569))
"Denise" wrote in message
...
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