View Single Post
  #1   Report Post  
Old August 28th 19, 07:46 PM
Andrea P Andrea P is offline
Junior Member
 
First recorded activity by ExcelBanter: Aug 2019
Posts: 5
Default IF function + NBCAR

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.

The first row 1 does not contain data, it's the titles. And all the following rows are the data. So I had =LEN(G2) for every N cell row with their corresponding G cell number.

Also, I work with the French version of Excel and so I can find the equivalents for the terms but I don't if the punctuation changes across languages... does it?

Can I ask questions about macros in here or not really?

Thank you!

Andréa

Last edited by Andrea P : August 28th 19 at 07:51 PM