How to build IF statement

Microsoft Excel 2010
April 13, 2011 at 17:39:03
Specs: Windows 7
Hello there;

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):
G H
10 10
10 25
10 80 OPTIMUM VALUE WHICH SHOULD PRINT “FAIL”
30 10
30 30
30 80
80 10 OPTIMUM VALUE WHICH SHOULD PRINT “PASS”
80 30
80 80

I have tried several combinations and always failed to build the IF STATEMENT. Please, help me if you can.


Regards


See More: How to build IF statement

Report •

#1
April 13, 2011 at 18:44:59
Try this:

=IF(AND( G10<=25, H10>=75, H10>G10),"FAIL",IF(AND(H10<=25, G10>=75, G10>H10),"PASS",""))

MIKE

http://www.skeptic.com/


Report •

#2
April 14, 2011 at 15:01:05
Thanx...I will get back to you later, however, It may take me longer than usual because I found some mistakes in the formulas I have. I must fix them first.

Report •

#3
April 15, 2011 at 07:49:05
YAHOOOOOOOOOOO....

Thanx a lot... After I fixed the formulas, everything worked excellent. What's funny is that I have built the same formula you built, but because I had wrong calculations in the other cells, it never worked out. your formula actually made me doubt my calculations.


Big thanks to you brother..


Report •
Related Solutions


Ask Question