3 Replies Latest reply: Oct 30, 2017 12:31 AM by Shraddha Gajare RSS

    Nested if error

    Santhosh Ashokkumar

      Can someone figure out what is wrong. It says ok but unable to visualize.

       

      count (If(Match([R1],'A' ,

      'B','C' 

      ),'Good')

      and

      If(Match([R2],'C','D', 'Good' ),'Good')

       

      or

       

      If(Match([R2]'C','D', 'Good' ),'Good')

      and

      If(Match([R3],'C',

      'E','Good'))

       

       

      count (If(Match([R1],'C' ,

      'F'),'Good)

      and

      If(Match([R2],'E' ),'Good')

       

      or

       

      If(Match([R2],'E'),'Good')

      and

      If(Match([R3],'C',

      'E'),'Good'))