![]() ![]() You can build a simple formula to do this with the LEN function and this expression: LEN(B5:B9)>5įor each of the five cells in the range, LEN will return a character count, which will be checked with >5. Let's say you have a list of words in a range, and you want to count how many contain more than 5 characters. That might sound pretty vague, so I'll illustrate with the example above. ![]() It's used in formulas where numbers are needed for a particular math operation. ![]() The double negative (sometimes called the even more nerdy "double unary") coerces TRUE or FALSE values to their numeric equivalents, 1 and 0. What the heck is that, and what is it doing? In more advanced Excel formulas, you might run into the double negative operation (-): ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |