| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If result of formula is "" (Blank) why is this considered a num.
I have a cell formula that returns either a number or "" (blank). This works
fine but when I try to compare the result with another number to see which is greater, I'm having trouble figuring out how Excel treats the result. If the formula returned a number (say 2.0) and the other cell contained say 3.0, then Excel can correctly recognise that 32. However, if the result was "", then it says that ""3. I don't know why this is. You would think that "" would be treated as zero which would be less than 3, not greater than. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Threaded Mode
