Getting error while entering formula into write cell

Hi Team,

I am getting below error after entering formula into write cell.
“character constant must contain exactly only one character”

Formula:
=IF(C2=“Composite”,“Separate Accounts”,IF(C2=“Pooled”,“Pooled Funds and Managed Accounts”,IF(C2=“Configured Unified Managed Account”,“Pooled Funds and Managed Accounts”,IF(C2="",“Separate Accounts”,IF(C2=“Collective Investment Trust”,“Collective Investment Trust”,“Error”)))))

Please help me out.

In the formula, please replace each double quote with two double quotes.

For example, "=IF(C2=""Composite"".....

Except first and last…

1 Like

Thnx Karthik. It work for me (y)

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