IF Function

Options

Hi,

I am trying to create a formula one which there is two calculated values.

Here is what I created below.

=IF(ColumnName1< ColumnName2 - 3 * ColumnName3, IF(ColumnName3 > ColumnName2@ * 3, "True"))

Does not work for me...

First half of calculation

=IF(ColumnName1< ColumnName2 - 3 * ColumnName3

Second half of calculation

IF(ColumnName3 > ColumnName2@ * 3

If the two calculated values are equal = I want to be "True"

If the two calculated values "are not" equal = I want to be "False"

Any help with this is appreciated.

• ✭✭✭✭✭
Options

I believe the formula you want is the following:

`=IF(ColumnName1 < (ColumnName2 - (3 * ColumnName3)), IF(ColumnName3 > (ColumnName2 * 3), 1, 0), 0)`

Connor Hartford

• ✭✭✭✭✭
Options

I believe the formula you want is the following:

`=IF(ColumnName1 < (ColumnName2 - (3 * ColumnName3)), IF(ColumnName3 > (ColumnName2 * 3), 1, 0), 0)`

Connor Hartford

• Options

Thank you Mike and Connor question if you don't mind:

What does the 1 and 0 represent? Yes/No?

So for another formula would this be the way to create it

=IF(Col < 9), IF(RV1@row >1), 1,0))

• ✭✭✭✭✭✭
Options

The way the IF statement is built is like this.

`=IF([column Name]@row = this, "Then return this result", IF([Column Name]@row > "this" , "then return this text", "this will return if none of the other statements are true)) `

So if you are wanting to compare some cells you would want to do it in the first section after the first IF statement.

• ✭✭✭✭✭
Options

Yes `1` would equal "True" and `0` would equal "False", or Yes/No. Instead of `1` you can put `"True"` and instead of `0` you can put `"False"` in the same spot. It depends if you want it to show a 1 or 0 or the word "True" or "False", and it depends on the column type.

Your second formula has too many parentheses. I think it should look like this:

=IF(Col < 9, IF(RV1@row >1, 1,0))

OR

=IF(Col < 9, IF(RV1@row >1, "True","False"))

Connor Hartford

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!