Formula gets rejected

S

Surak

Hi all
Excel just don't accept my formula. I got the formula out of a paper to calculate the correlation of specific values

=IF (OR (IF (AO>AM, AM/AO, AO/AM) < 0.9, IF(AP>AN, AN/AP, AP/AN) < 0.9), 'Bad', 'Good'

Excels says there're errors in the formula, but I can't find them. I tried everything I could think of. Can somebody help
Thank

Surak
 
J

J.E. McGimpsey

See one potential answer in my reply to your previous post.

If you're entering the formula as shown, the problem is that you're
not specifying a row number, and you need to replace your single
quotes with double quotes, and eliminate the spaces after the first
IF and OR.
 
G

gocush

Sorry,
I put the following answer in a REPLY to you post.


When building nesting IF STATEMENTS, I find it helpful to start in th
middle and build out:

Note: A,B,C and X,Y and Z are all "CONDITIONS" you are testing.

OR(A,B,C)
=IF(OR(A,B,C),"BAD","GOODBYE")
OR(X,Y,Z)
=IF(OR(X,Y,Z),"GOOD","HELLO")

=IF(OR(A,B,C),"BAD",IF(OR(X,Y,Z),"GOOD","YANKEES"))

Also note that EACH IF clause has 3 parts --
1 the conditions which are checked
2. what happens if all conditions are met
3. what happens if all conditions are NOT met
In my last formula, I have nested a second if statement which is no
the 3rd part of the 1st statement.

HT
 
G

gocush

The meaning of:

=IF(OR(A,B,C),"BAD",IF(OR(X,Y,Z),"GOOD","YANKEES"))


is

If either A or B or C is true then enter "BAD" (end of story)
If none of the above, then if either X or Y or Z is true, then ente
"GOOD" (end of story)

If none of the 6 conditions is true then enter "YANKEES
 
Top