2 Replies Latest reply on Dec 12, 2017 10:47 AM by Hari Ankem

# IF CONDITION BLANK CELLS

Hi everybody,

I wish to calcul a sum of a column "(montant kwh cumac)" if many conditions are correct. These conditions are :

Column (résultat CEE) = "oui" OR "peut-être"

Column (montant kwh cumac classique) = empty or "0" AND Column (montant kwh cumac précarité) = empty or "0"

Column (Type de précarité)="aucune" OR empty

The calculated field that i used is the following :

IF [Résultat CEE 2017]="oui" OR [Résultat CEE 2017]="peut-être" AND  ISNULL([Montant (kWh cumac) classique]) AND ISNULL([Montant (kWh cumac) précarité]) AND [Type de précarité]="aucune" THEN [Montant (kWh cumac)] END

The result of this calculation is not correct. I believe that ISNULL does not count the blank cells

Can you please help me find the correct formula ?

Many thanks

• ###### 2. Re: IF CONDITION BLANK CELLS

Try this:

IF  ([Résultat CEE 2017]="oui" OR [Résultat CEE 2017]="peut-être")

AND ZN([Montant (kWh cumac) classique])=0

AND ZN([Montant (kWh cumac) précarité])=0

AND (ISNULL([Type de précarité]) OR [Type de précarité]="aucune")

THEN [Montant (kWh cumac)]

END