Nested if error

[santho_ak]

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

[Anonymous]

‌looking at this you have two count clauses but no addition symbol between them.

[sunny_talwar]

What exactly are you trying to count?

[shraddha_g]

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