View Single Post
  #5   Report Post  
Old August 29th 19, 04:20 PM posted to microsoft.public.excel.worksheet.functions
Benoît Benoît is offline
external usenet poster
First recorded activity by ExcelBanter: Jun 2019
Posts: 6
Default IF function + NBCAR

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:


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
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:

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

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