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.

Best Answers

Answers

  • Connor Hartford
    Connor Hartford ✭✭✭✭✭
    Answer ✓
    Options

    I believe the formula you want is the following:

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


    Connor Hartford

  • Allie Gentry
    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))

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    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.

    Sharing a screenshot might help us help you better.

  • Connor Hartford
    Connor Hartford ✭✭✭✭✭
    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!