Comparing scenarios

[renjithpl]

Hi guys...

I have a challenge. I have two fields, ResponsiveCatCode and ResponsiveCategories. I want formula for certain scenarios.

If ResponsiveCatCode = ResponsiveCategories, it should not show Error AND ResponsiveCatCode not equal to ResponsiveCategories, it should give 'Error1' AND if ResponsiveCategories is blank, it should give 'Error2'.

I tried with the below formula,

=If(ResponCatCode<>ResponsiveCategories, 'Error1' & If(ResponCatCode=ResponCatCode & IsNull(ResponsiveCategories), 'Error2'))

but it dint work..

Please help me…

[#2]

Try something like this (2 If statements encapsulated):

=If(ResponCatCode<>ResponsiveCategories, 'Error1',If(ResponCatCode=ResponCatCode & IsNull(ResponsiveCategories), 'Error2')))

[Anonymous]

Think you already where on the right path with the solution ... but only the if should be build up differently ...

If(ResponCatCode<>ResponsiveCategories, 'Error1',
 If(ResponCatCode=ResponCatCode and IsNull(ResponsiveCategories), 'Error2'))

Anita