Parentheses Placement IF/AND Formula?

[artiststevens]

Hello,
I need help with the parentheses placement for some (IF/AND) formulas the result isn’t correct for some and Excel gives me errors messages for others. If you could review the formulas and see if which ones contain errors and which ones are correct it would be greatly appreciated.

Thank you.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Speshul]

=AND((Q6-P6)/(O6-P6)>=0.6,(N6-P6)/(O6-P6)>=0.6)

I might be wrong but I think order of operations states that you are doing this:

=AND((Q6-P6)/(O6-P6)>=0.6,(N6-P6)/(O6-P6)>=0.6)
Then dividing the TRUE/FALSE by (N6-P6)

Try
=AND(((Q6-P6)/(O6-P6))>=0.6,((N6-P6)/(O6-P6))>=0.6)

[Paul]

Excel performs calculations prior to comparisons.

If you click Evaluate Formula on the Formulas ribbon you should see where your errors are.

[ben_hensel]

1-2 look fine to me,
3-6 have AND(one - two) which is going to deliver TRUE as long as they're both numbers,
7-8 look fine.

[artiststevens]

Thank you everyone for the help it's greatly appreciated.