Thread: blank values
View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default blank values

What does this formula return?

=LEN(I4)



--
Regards,

Peo Sjoblom

(No private emails please)


"etefonori" wrote in message
...
I have a formula =IF(I4="","",IF(I4<J4,1,0)) that in other worksheets is
leaving the cell blank but in this particular worksheet it always returns
a
value 0 or 1 even if I4 is blank