Excel formula, extra quotes?

[MikeC (Mike)]

Hi Guys,

Quotation issues here, 1st is the actual excel formula.
=IF([@[ACCOUNT STATUS]]>=0,“CR”,“DR”)

Below ive placed extra quotations but getting an error.
“=IF([@[ACCOUNT STATUS]]>=0,”“CR”“,”“DR”“)”

[Anil_G (Anil Gorthi)]

@MikeC

I am not sure what @Account Status does…but its not the quotation issue…mostly looks like the formula is little off…can you please check it on excel…

cheers

[MikeC (Mike)]

Hi Anil,

Formula works perfectly, “Account Status” is a table header.

Thanks

[MikeC (Mike)]

God damn it, my bad, had the wrong bloody table header

Should be
“=IF([@[ACCOUNT BALANCE]]>=0,”“CR”“,”“DR”“)”

Thanks Anil

[Anil_G (Anil Gorthi)]

@MikeC

Happy Automation…there must be something else only off…good to know

cheers