IF() not working in a cell of Excel attachment

AppSheet AppSheet Q&A
,
1

Hello there,

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

2

I would guess you’re doing something wrong.

1 Like
3

@Steve Please check this.

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

4

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.