IF function + NBCAR
Hi Andrea,
Am Wed, 28 Aug 2019 19:46:12 +0100 schrieb Andrea P:
I would like to have a formula that only applies to a cell if another
has been filled beforehand.
So cells in the column G might contain a text.
Colum N has to show the number of characters that column G contains
(=LEN) but I don't want column N to contain the number 0 if column G has
no text. I would rather have column N blank.
So for example:
/// A..B..C...G......................................N
1.....................asdaljda.................... ...8
2....................-.........................................
3....................sdjf......................... .........4
try:
=SI(NBCAR(G1)0;NBCAR(G1);"")
You can post questions about VBA in
microsoft.public.excel.programming
Regards
Claus B.
--
Windows10
Office 2016
|