IF Formula for if Value is not greater or less than a specified value

[mutzie]

Hi Guys,

How do I go with the the formula if I need to check if the difference between the 2 values are not more than a specific value.

For example

Cell A1: 100.23
Cell B1: 100. 15
Cell C1: formula to check if the difference between A1 and B1 will not exceed 1.00 or -1.00, sample condition would be "GOOD" for not exceeding, and "BAD" if the differences is more than 1 or -1

Thank you!

[davsth]

if(abs(a1-b1)<=1,"Good","Bad")

[AlKey]

Or

Please Login or Register  to view this content.