I am trying to write an IF statement. The calculations in the excel sheet will be done through several steps.
First, there will be entries in several cells. Whatever the entries in these cells, the outputs in cells G2 and H2 will ALWAYS range between 0.0 and 100.00 because they are percentage numbers. Until this point, I have no difficulties in the formulas.
I will then use the values in G2 and H2 to build an IF statements in cells J2. The value in cell J2 is generated based on the following:
IF G2<=25 and H2>=75 and H2>G2 THEN PRINT “FAIL”
IF H2<=25 and G2>=75 and G2>H2 THEN PRINT “PASS”
NOTE 1: I am requiring "AND" not "OR", which means I need ALL the conditions to be satisfied.
NOTE 2: We should ignore any other case.
NOTE 3: We may use the word “suspicious” for any other output, however, it is not necessary.
If I am right, here are the possible outputs for cells G2 and H2 if I did not miss any (remember: all values in G and H are percentages):
10 80 OPTIMUM VALUE WHICH SHOULD PRINT “FAIL”
80 10 OPTIMUM VALUE WHICH SHOULD PRINT “PASS”
I have tried several combinations and always failed to build the IF STATEMENT. Please, help me if you can.