lundi 6 juillet 2020

How to reference a value of a cell, combine it with a choice in a list, and output true/false

I am making a test report for work. The limits of the test are greater than/equal to 100kHz, less than 500MHz. The numerical value will be user inputted. The frequency (kHz,MHz,GHz) will be a choice in a list using data validation.

I want to create a PASS/FAIL scenario where if the user inputs a value, (cell A1), of 250 and chooses kHz (cell B1), the formula will compare the choices to the limits and provide me with a PASS or FAIL depending whether it satisfies the limits.

Usually, I use the following formula for min/max:

=IF(AND(A1>=MIN(),A1<=MAX()),"PASS","FAIL") 

I've been able to use this formula for singular greater than/less than:

=IF(ISBLANK(A1),"",IF(ISBLANK(B1),"",IF(AND(A1<700,G96=K14),"PASS","FAIL")))

But I need a way to combine the two formulas.

Aucun commentaire:

Enregistrer un commentaire