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