Getting error BC30198: ")" and error BC0004

HI, I am getting error BC30198: “)” and error BC0004 when entering the formula “=IF(D3<72400),“None”,IF(D3<217200,“Member”,IF(D3< 434000,“COT”,“TOT”)))” into write cell activity

@ray1

After 72400 ) closing bracket is wrong

And for every inverted comma inside the first and last use double inverted comma ""

Cheers

Much appreciated, Thank you very much

1 Like

@ray1

Please close if resolved else happy to help

Cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.