Hello, I get the following error when trying to run this formula. I have the Output Column selected as "Site Formatted" which is formatted with Integer 16.
"Parse Error at char(298): Malformed If Statement (Expression #1)"
if [Site Formatted]=10 then 3810
else if [Site Formatted]=12 then 3812
else if [Site Formatted] = 14 then 3814
else if [Site Formatted] = 22 then 3822
else if [Site Formatted] = 36 then 3836
else if [Site Formatted] = 38 then 3838
else if [Site Formatted] = 41 then 3841
else [Site Formatted] endif
Any idea what I might be doing wrong?
