IF statement

[Anonymous]

I am looking for a way to create an IF statement that works to create the "New Column"

If ( cuts = 1, " Savings amount", "0") 

I am having trouble creating the "New Column" Values based off the above IF statement. 

Saving    Cuts     New Column

  92.00       0              0

  23.00      1              23

    15         1              15

     0          0              0  

    12.00    0              0

  900.00    1            900

[Anonymous]

Hi, 

I'm not sure what you're asking for exactly but sounds like the conditional column can create what you need. 

Go to add a column, conditional column 

for example 

[az38 · Accepted solution]

@Anonymous 

it's unclear your desired output but I can suggest your column will look like

New Column = IF([cuts] = 1, [Saving], 0)

[Anonymous]

Apologies for the confusion but this is exactly what I needed. I had "0" in my formula so that was the reason it did not work.