Need help with an IF, OR formula
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

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
Categories
Check out the Formula Handbook template!