IF Formula

[Denise]

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

 

[Cody]

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

try this.

Cody

 

[Anne Troy]

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

 

[Denise]

This worked.

THANKS!!!!

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

try this.

Cody

 

[Cody]

You're Welcome!

This worked.

THANKS!!!!

 

[Bob Phillips]

--

HTH

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

 

[Bob Phillips]

Just for fun

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

--

HTH

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