Hello. First time poster; wish I would've known about this forum years ago.
Here's what I want excel to do, but don't know the formula:
I need excel 2007 to compare two cells; temperature in this case. If cell two is within 3 degress of cell one, then the result should equal 1 (arbitrary number to state that the temperature was in tolerance), if cell two is 4 degrees or greater than cell one, plus or minus, then the result should be 0 (to show temperature outside of tolerance).
Thank you.
Bookmarks