Formula HELP

I am trying to use this formula. but I am getting error.

if [Account Group] = "CAPL CE"
or
"COMPTR"
or
"SW SEH"
Then [Fixed Asset After Adjustment] else 0

Can someone please help me to fix this formula?

Developer

Accepted answers

Formula should be

if [Account Group] In ("CAPL CE","COMPTR","SW SEH")
Then [Fixed Asset After Adjustment]

Else 0 Endif

Hope this helps : )

if [Account Group] IN ("CAPL CE", "COMPTR", "SW SEH")
Then [Fixed Asset After Adjustment] else 0 ENDIF

Formula should be

if [Account Group] In ("CAPL CE","COMPTR","SW SEH")
Then [Fixed Asset After Adjustment]

Else 0 Endif

Hope this helps : )

YOU ARE AMAZING!!! Thanks.

Happy to help : ) @rrahu07

Cheers and have a nice day!