J
Joe
What is the correct format to test for multiple conditions in an IF
statement? I want to test if both of two conditions are correct.
The format I am using is =IF((D14>15) AND (G14="Y") . . .) but Excel won't
accept that saying that the "logical test" is invalid. Both cells being
tested do exist.
Any ideas?
statement? I want to test if both of two conditions are correct.
The format I am using is =IF((D14>15) AND (G14="Y") . . .) but Excel won't
accept that saying that the "logical test" is invalid. Both cells being
tested do exist.
Any ideas?