VideoPhoto

Showing posts with label TRUE. Show all posts
Showing posts with label TRUE. Show all posts

08 November, 2021

CELLS: Blank, Empty, Space, Zero

Back to basics... 

What's the meaning of all these basic terms in Excel?

BLANK cell: empty or not? Not quite, may contain "" (zero length text string)

EMPTY cell: nothing is there (no text string, no zero); always evaluates to zero

Cell with SPACE: contains 'space' character (=" ")

Do you know that: 

08 October, 2021

Function N() = Insert Comment: TRUE or FALSE

When we return to our workbook created some time ago and try to revive/use it, it quite often happens that we've forgotten what we had intended to achieve by composing some complex formulas or entering even simple data points. We can avoid such situations in the future by adding comments or notes to some cell contents.

The Insert Comment feature is OK, but in most cases the better choice is to use the N() function, as illustrated below: