Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ISTEXT evaluates to 0 ? (not FALSE)
Hello.
I have a subroutine that uses a formula to determine if a cell is the same as the one below it, and the formula, =EXACT(a1,a2) is evaluating properly in some cases, and in others, it's returning #VALUE on the last row of data... where it compares a cell with data, vs. a blank cell. What I've noticed with the spreadsheets where it works is that the logical functinos, =isnumber and =istext , etc., evaluate to TRUE or FALSE, as they are supposed to. However, on the spreadhseets where =EXACT fails, the logical functions evaluate to 1 or 0. I know those are the same things, thinking in a Boolean manner, but it's consistent. It appears to be newly created sheets that work fine, and sheets that have had other data on them in the past which fail. Is there a setting or property that you know of which would cause this behavior? Thanks, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank cells: ISBLANK = FALSE, ISTEXT = TRUE | Excel Worksheet Functions | |||
What is function that evaluates other functions indirectly? | Excel Worksheet Functions | |||
Please help - formula works in some cells but evaluates to #value in others | Excel Worksheet Functions | |||
ifcount evaluates always false | Excel Programming | |||
Data Validation preventing ISTEXT() from reading FALSE in '97 | Excel Discussion (Misc queries) |