If cell value is equal to or between values

Hi All, looking for help with the following.
Cell B7 = required length.
Cell G7 = actual length.
Cell G5 = minimum length.
Cell H5 = B7 + 10
Cell I5 = B7 + 1%
Cell J6 = Result

I would like J6 to display "PASS" if G7 is equal to G5 or Between G5 and H5 or I5

J6 would display "FAIL" if above is not met (or G7 is less than G5 or not Between H5 and I5)
Background would be solid red for fail and solid green for pass.

So in words the measured length must be equal to the required length (no less) and equal to the required length + 1% or 10 (not %) whichever is the greatest.
Example 1
800mm required.
Measurements and results below.
799- Fail
800 to 810 Pass
811+ Fail

Many thanks for looking.

how about
=If( And( B7>=G5, OR( B7<=H5, B7<=I5)), "Pass", "Fail")


A sample sheet would help here, and possibly will enable a quicker and more accurate solution for you.


The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Another option:

Formula:

Please Login or Register  to view this content.

did you try my suggestion
=If( And( B7>=G5, OR( B7<=H5, B7<=I5)), "Pass", "Fail")