Complicated IF Formula

[Coconutdog]

I've developed a basic spreadsheet to account for physically present bags compared to what the accounting system says should be in stock. My client says that he's not fussed if there is a discrepancy of ±15 bags, this is not to be reported. This discrepancy usually occurs if a customer has purchased some bags and the accounting system is yet to catch up whilst I am doing my counts. Anything over or under 15 bags is to be adjusted. The formula I am currently using is this:

=IF(F6=G6, "No","Yes")

Can this formiula be amended to allow for the ±15 bags requirement?

At present, any discrepancy shows up as being adjusted. I'm far from being an Excel guru and would appreciate any help. Cheers.

 

[Eric W]

Welcome to the MrExcel forum!

Try:

=IF(ABS(H6)<=15,"No","Yes")

 

[Coconutdog]

Welcome to the MrExcel forum!

Try:

=IF(ABS(H6)<=15,"No","Yes")

Thanks Eric, that works. Very simple fix.

Matt.