IF statement when datapoint may or maynot be zero

[Valeri]

Good morning to all – I am a registered “newbie”, but I’ve been lurking for several years Can you help me with the following – this is day 2 of the headache?

The min/max numbers are entered from the required spec. into columns B and C. The actual test results as whole numbers are entered in column E16 with the following located in column F to indicate pass/fail:

=IF(E16<B16,"FAIL",IF(E16=B16,"PASS",IF(E16>C16,"FAIL","PASS")))

I have attached the form.

My problem - the requirement for “maximum” may or may not be required. Therefore, if the maximum is NOT required, the pass/fail needs to be based the concept that if the result is >= the minimum it passes. If it IS required, the pass/fail needs to be based on the concept of >=minimum and <= maximum.

All help will be greatly appreciated.

[DBY]

Hello
Perhaps the following formula might do the trick, if I've followed the logic correctly, copied down from cell F16:

Please Login or Register  to view this content.

Hope this helps.
DBY

[Valeri]

DBY - this is WONDERFUL - thank you ever so much!!! No more headaches (at least for awhile). Valerie