It's hard to tell what the solution would be since we don't know your data types.
could you attach some sample data/workbook?
From the looks of it though, try removing "THEN [Initial Lien]"
IF [LienType] = "Medicare" THEN = "N/A"
ELSE [Initial Lien]
Initial Lien is an integer.
Lien Type is a string/ category
Taking away THEN [Initial Lien] won't work because it needs to know where I want N/A displayed.
Such as I want it to display the integer for our final lien amount but the initial lien value is no applicable so I'd like it to say N/A instead.
Anyone else come across this issue before?