This content has been marked as final.
Show 2 replies
-
1. Re: IF CONDITION BLANK CELLS
Deepak RaiDec 12, 2017 10:44 AM (in response to Karim ZAKI)
Please attach some sample workbook to help you.
-
2. Re: IF CONDITION BLANK CELLS
Hari Ankem Dec 12, 2017 10:47 AM (in response to Karim ZAKI)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