| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
blank values
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
blank values
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| zero values in charts-don't want to show as zero, but as blank | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
