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" wrote in message
...
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.