View Single Post
  #4   Report Post  
Old August 29th 19, 03:56 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,763
Default IF function + NBCAR

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.

Claus B.
Office 2016