1 Reply Latest reply: Apr 6, 2012 12:37 PM by Celambarasan Adhimulam RSS

    Using NEST IF statements

      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'
      )
      )
      )