Another possibility is =IF(ISERROR(K6-L6),"",IF(K6<25,25,K6-L6))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Keith" <Keith@discussions.microsoft.com> wrote in message
news:77BF9398-29F0-4AB8-A330-8C47EBCA36AD@microsoft.com...
>I am trying use the following formula in cell M6. =IF(K6<25,25,K6-L6) but
>it
> returns "value!" if K6 is blank. But if K6 is blank I want it to leave
> the
> cell blank. I have tried everything I can think of. Could you help me
> with
> this.