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
|