IF() not working in a cell of Excel attachment

[Akshay_patel95]

Hello there,

<<IF: Condition>> condition is not working in a cell of Excel attachment Template. 

[Steve]

I would guess you're doing something wrong.

[Akshay_patel95]

@Steve  Please check this.

<<IF: OR([Q001] = "1. Purchased electricity & Renewable Power Purchase Agreement", [Q001] = "2. Renewable & recovered energy")>> "N/A" <<EndIF>> <<IF: NOT(OR([Q001] = "1. Purchased electricity & Renewable Power Purchase Agreement", [Q001] = "2. Renewable & recovered energy"))>> <<[E016]>> <<EndIf>>

[Steve]

Looks OK to me. If it doesn't display anything, I'd guess your conditions aren't matching.

Make sure your spelling is correct, especially for those long match strings.

Can [Q001] produce a blank value? If so, you should handle that explicitly.