Creating new column using Formula Tool to create a percentage output

[jjimenez]

Hello!

I need help with this last portion of my workflow. I'm creating a new column "MAX CEILING" and based on the Name in another column, the new column will populate a different output.

I want to populate "1.30" if Name in another column is "Foreground"

If Name is "Background" in same column then populate "1.50" on each row.

2nd formula:

If Name is "KVI" then pull data from column "Target Index" and "Super KVI" pull data from "Target Index" on populate what's present in that row.

Here is a snapshot: I'm getting Parse Error at char(35): Malformed if Statement (Expression #1)

Any help will be greatly appreciated. 

[jjimenez]

THANK YOU! I will try this now. I really appreciate it. 

You tutor Alteryx on the side :)?