If condition issues

[risabhroy_03]

This is my condition 

If Purchase Type= “RM\BOP” and Overall Category & MIS Grade Category are blank, then show purchase type else display null.

This is my code but it shows everything as NULL

=if(([Purchase Type]='RM\BOP') and ([Overall Category]=' ') and ([MIS Grade Category]=' '),[Purchase Type],Null())

[Taoufiq_Zarra]

@risabhroy_03  can you try like

if(match([Purchase Type],'RM\BOP')>0 and len(trim([Overall Category]))=0 and len(trim([MIS Grade Category]))=0,[Purchase Type])

[risabhroy_03 · Accepted solution]

I used this and it worked perfectly 

=If(([Purchase Type]='RM\BOP') and ([Overall Category]='-') and ([MIS Grade Category]='-'),[Purchase Type],Null())