Using NEST IF statements

[#1]

I was having some problems getting nested IF statements to work and I thought this maybe helpful to others.

I wanted to change the default background colour in a column in a table based on the value in the column and this was the structure of the IF statement that worked for me.

=IF(
'CONDITION 1'
,  'ACTION 1'
,IF('CONDITION 2'
,'ACTION 2'
,IF('CONDITION 3'
,'ACTION 3'
,'DEFAULT ACTION'
)
)
)

[CELAMBARASAN]

Hi,

     Sometimes this may also helpfull for others.

     =Pick(WildMatch(FieldName or Expression,'Value1','Value2','Value*','*'),'Action1','Action2','Action3','Action4')

Celambarasan