View Single Post
  #3   Report Post  
Old August 29th 19, 03:31 PM
Andrea P Andrea P is offline
Junior Member
 
First recorded activity by ExcelBanter: Aug 2019
Posts: 5
Default

Hello!

Thank you so much for your fast answer.

I got an error message saying the formula is incoherent. It proposed me to add an asterisk (*) as follows:

=SI(NBCAR(G70)*0;NBCAR(G70);"")


But it still does not work. I want N to show the number of characters that G contains (if it contains any).

Thank you!

Quote:
Originally Posted by Claus Busch View Post
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