Hi! I desperately need a help. How can I compare value to a range of values in a single cell? E.g. column A contains 5, 17, 4, 9 etc. column B contains 6-5, 19, 5-4, 9 etc. and column C should show 0, -2, 0, 0 etc. Hope that makes sense....I was trying IF, AND formulas, but no success(((