ExcelBanter - blank values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - blank values (https://www.excelbanter.com/excel-worksheet-functions/53083-blank-values.html)

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

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

If was returning an 0 or 1 - what I figured out was even though the orginal
cell appeared empty there must have been something left - I cleared the cell
completely and it now works.

Thanks anyways!

"Peo Sjoblom" wrote:

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