Need help with an IF, OR formula

Noreen Hunt

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".

Rich Stowell

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"))