I'm having a hard time trying to convert an Exce formula like the following one to the Custom Formula options in Zoho Advanced analytics: 

=IF(A3=B3,"service",IF(B3=C3,"project",IF(A3=C3,"shelf","")))

Besides, is it possible to use AND - OR - NOT operators in Zoho Reports Formulas? What are the rules or correct syntax to use them!!??

Thanks!

Br,

Efrain