Claus Busch wrote:

Hi Andrea,

Am Thu, 29 Aug 2019 15:31:48 +0100 schrieb Andrea P:

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);"")

my posted formula should work. I guess the issue is caused by the
separators. I don't know what separators are used in a french system.
Try my formula and change the semicolon to comma.

You could use only
=NBCAR(G70)
and deactivate "In cells with zero values show 0" in the options.


Since SI = IF there has to be a « reason if » so I would write:
=SI(NBCAR(G70)=0;NBCAR(G70);"")
^^^

It's in fact (IF;THEN;ELSE)


--
Vie : n.f. maladie mortelle sexuellement transmissible
Benoit chez lui à leraillez.com

Hi Benoit,

For some reason, it also doesn't work... I have a message saying that the formula is incoherent.

The N cell is indeed blank but it doesn't show any number when the G column does have characters in it.

Help!

Hi Andrea,

Am Fri, 30 Aug 2019 20:26:59 +0100 schrieb Andrea P:

Unfortunately, I need those cells to be blank because I'm making an
macro that updates the sheet. When I press Ctrl+A, it usually only
selects the actual used range. But with the option to not show the
zeros, the cells are still filled so I have a very big range selected
which slows the macro down.

download the file from he
https://1drv.ms/x/s!AqMiGBK2qniTgeV9...sVDLg?e=QJRpUh
When you open it on your system, the formulas should be translated to
French.


Regards
Claus B.
--
Windows10
Office 2016