A truly blank cell acts as if it was zero [ if B1 is blank and B2 contains -1 then B2>B1=FALSE] but excel considers that any text value is greater than any number....and a "formula blank", i.e. "" returned by a formula, acts like a text value
A truly blank cell acts as if it was zero [ if B1 is blank and B2 contains -1 then B2>B1=FALSE] but excel considers that any text value is greater than any number....and a "formula blank", i.e. "" returned by a formula, acts like a text value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks