Formula

Stephanie Taylor

If column 1 has the word "yes" is there a formula that will place a value of "482000" in column 2?

Thanks in advance

 

 

Andrée Starå

Hi Stephanie,

Try this.

=IF([Column 1]1 = "Yes"; 482000)    

The same version but with the below changes for your and others convenience.   =IF([Column 1]1 = "Yes", 482000)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Stephanie Taylor

Andree,

Thank you, that works great!  Now let me take it one step further.  How do you adjust the formula to include if column 1 is "No" then the value in column 2 is "481000"?

Thanks again,

Steph

 

 

Andrée Starå

Happy to help!

Try this. I've also updated the formula with the @row function so you don't have to worry about the row numbers.

=IF([Column 1]@row = "Yes"; 482000; IF([Column 1]@row = "No"; 481000))    

The same version but with the below changes for your and others convenience.    

=IF([Column 1]@row = "Yes", 482000, IF([Column 1]@row = "No", 481000))

Best,

Andrée

Stephanie Taylor

Thanks for your help.  It worked just like I wanted it to.  

Andrée Starå

Great!

I'm always happy to help!

Best,

Andrée