Formula HELP

[rrahu07]

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?

[ChrisTX]

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

[atcodedog05 · Accepted solution]

Hi @rrahu07 

Formula should be

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

Else 0 Endif

Hope this helps : )

[rrahu07]

YOU ARE AMAZING!!! Thanks.

[atcodedog05]

Happy to help : ) @rrahu07 

Cheers and have a nice day!