I have a Sheet we use to fill out and determine if a certain dimension is good from our report. I would like this to automate and figure out if the dimension is within tolerance or not for all rows.
I would like the formula to place an X in the "OK" box if the result in the J column is between F+G and F-H, Otherwise put an X in the "Not OK" box.
Example: J9=179.886 F9+G9=179.900 F9-H9 = 179.860 Therefor there should be an X in the OK box (column N) (See attached sheet)
Bookmarks