![]() ![]() This formula uses ISBLANK, which returns either True or False, depending on whether the referenced cell (A3) is blank or not. Instead of using =A3 as your formula, you would use the following: This seems to be related to the idea that it is impossible for a formula to return a blank value, when "blank" is used synonymously with "empty." You can, however, expand your formula a bit so that it returns an empty string. In that case, the formula returns a value of zero. ![]() For instance, if you have the formula =A3, then the formula returns the contents of cell A3, unless cell A3 is blank. ![]() If you have a formula in a worksheet, and the cell referenced by the formula is blank, then the formula still returns a zero value. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |