This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’m trying to write a simple IF statement in the CM Maturity Date column comparing the Policy Type field and outputting either a DATEADD function, if “Claims Made”, or a text string (“N/A”) if “Occurrence”:
This is the formula that I currently have ...
I fixed the quotes, which took care of the error, but I’m still only getting the N/A in every row, even for Claims Made policy types. It’s like it sees all the policy type entries as Occurrence.
