Match two numbers +/-1

[Guz99]

I have a problem that I can't solve even though it is probably very simple. I have two calculations, one from a P&L report and from a stock movements report. I want to check that these numbers are in balance within 1. EG. P&L number is A1 : 200,000.21 and the movements report number is B1 : 200,000.54, obviously I can't do A1 = B1 as it results in a false. Is there anyway that I can do A1 = B1 with a variance <1 or >1? Or A1-B1 is <1 or >-1?
I've racked my brain trying to make this work.
Thanks,
Guz

 

[njimack]

=round(a1,0)=round(b1,0)

 

[Colin Legg]

=abs(a1-b1)<1

 

[Guz99]

=round(a1,0)=round(b1,0)

Thanks for the quick reply, but the problem with this is that one number could round up and the other down resulting in 1 difference, thanks anyway

 

[Guz99]

=abs(a1-b1)<1

This works wonderfully, I should have thought of that (it's been a long day)...

Thanks for that