Return value cannot skip blank cell

Hi, this was not too bad... after I cleared out all of the merged cells. If you need to make a cell wider, grab the column border at the top of the sheet, click & drag. Merged cells will cause endless difficulties for you... Use with care and (preferably) never. They're Ok for headers, but not so nice in data rows. Anyhow...

try this:

I am not clear about your requirement.

If one value is inside tolerance and one value is outside tolerance, what result do you want?

Dear Glenn,
The function work fine if the input value is 2 pcs. But i also need it to work if there's only 1 pc of input value.
FYI, this function is for a daily check sheet. Sometimes the inspect part is only 1 pc, & sometimes 2 pcs.( not always 2 pcs).

For ur question :

"If one value is inside tolerance and one value is outside tolerance, what result do you want?"

The return value is NG

Sorry if ur not clear about my requirement. Really appreciate ur help, Tq


Sent from my iPhone using Tapatalk

@namialus

Please Login or Register  to view this content.

Not seeing your data, but you could better believe Glenn, since you get in trouble with merged cells, sooner or later.

One more q...

If there is just one value and it is in specification, what do you want it to return - OK or NG?

Ignore; accidental duplicate...

If you only want to check on B17 you can use this formula.

Please Login or Register  to view this content.

Hi. I apologies... I completely forgot about you. I never answered your reply at posts 10 & 11. Well, I've sorted them out, but I am not completely sure if I understand what you were asking in post 12.

first of all, ake a look at this and see if it resolves the earlier posts. Then try to explain what more you need to have done to finish the job.

Thank you.. glad I was able to sort it out for you... eventually!