Need help with an IF, OR formula

Options

I am trying to write a formula for the following "If column A is greater than 55 = 1 or if less than 60 = 2. I have the first part but can't add the second--=IF([Process & Delivery Excellence]@row > 55, "1".

Answers

  • Rich Stowell
    Rich Stowell ✭✭✭✭✭
    Options

    Remember that an IF statement has 3 element ( the test, response if true, response if false). Try this:

    =IF([Process & Delivery Excellence]@row > 55, "1", IF([Process & Delivery Excellence]@row < 60, "2"))

    Note: in this format, once the first "true" statement is found, that is the answer. So as written above any value greater that 55 will return a "1" - you will never get to the 2nd IF. Therefore a value of 57 will return a "1". If you want values of 56 thru 59 to return a "2", then you have put that test first like this:

    =IF([Process & Delivery Excellence]@row < 60, "2", IF([Process & Delivery Excellence]@row > 55, "1"))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!