Compare data in 2 columns

[cgriggs]

Hey everybody,

I've been working on a spreadsheet to compare two columns of electric meter readings. I need to compare the two readings to make sure they are within 50 hours of each other.

Example:

Automatic reading: Manual Reading

54321 54333

There would be 12 hours different in the above meter readings and that would be acceptable. Now how can I translate that to a formula, I've been trying with IF and SUMIF but haven't gotten anything to work yet.

Thanks

Corey G

 

[njimack]

=IF(ABS(A2-B2)<=50,"OK","More than 50")