Question: I'm trying to use this formula, but Excel keeps telling me there's an error.

```
=SI(NB.SI(A2;"*D*");"Data";"SI(NB.SI(A2;"*V*");"Voice";"Autres")")

```

(In English:

```
=IF(COUNTIF(A2;"*D*");"Data";"IF(COUNTIF(A2;"*V*");"Voice";"Autres")")

```

)

I don't understand where it is. 

SI Means IF, I am using a french version on Excel 2010 on Win7.

As my English is not perfect, some things I'll say might sound weird. 

Here is a demo of what I am doing:

![Screeenshot](https://i.stack.imgur.com/A1PMi.png)

* IF D*x* Type Data
* IF V*x* Type Voice
* IF anything else, Type Autres.

*x* is a number. There are no other types, only “Data”, “Voice” and “Autres”.

It may be my own formula that is incorrect, if you have another way to type this, feel free to do so.

Answer: 
I don't have the french version, so I can't rule out that SI and NB.SI are good or bad. Assuming they're good, here is the formula broken down:

```
=SI
(
  NB.SI
  (
    A2;
    "D"              
  );                 *
  "Data";
  "SI                <
  (
    NB.SI
    (
      A2;
      "V"            
    );               *
    "Voice";
    "Autres"
  )"                 <
)

```

This tells me there are two " that are incorrect. These are highlighted above using the <. In addition the NB.SI formula is incomplete. NB.SI will return the amount of matches, but IF only checks for a true of false, so we need to change the amount of matches in a true or false by evaluating if they're more than 0. These are highlighted above using an \*.

The correct formula would be

```
=SI
(
  NB.SI
  (
    A2;
    "D"
  )>0;
  "Data";
  SI
  (
    NB.SI
    (
      A2;
      "V"
    )>0;
    "Voice";
    "Autres"
  )
)

```

or:

```
=SI(NB.SI(A2;"D")>0;"Data";SI(NB.SI(A2;"V")>0;"Voice";"Autres"))

```
=IF(COUNTIF(A2,"D\*"),"Data",IF(COUNTIF(A2,"V\*"),"Voice","Autres")) 

In French the following after your update: 

`=SI(NB.SI(A2;"D*");"Data",SI(NB.SI(A2;"V*");"Voice";"Autres"))` 

Maybe you should use SI instead of NB.SI if your Data in A2 is only D or V since no count is needed the formula become 

`=SI(A2="D";"Data",SI(A2="V";"Voice";"Autres"))` 

Or after your update: 

`=SI(GAUCHE(A2,1)="D";"Data",SI(GAUCHE(A2,1)="V";"Voice";"Autres"))`