Conditional Statement with ANDs

[Guest]

Hi. I'm trying to do the following:

Create a conditional statement where if a group of ideas are true, it will
produce the result. Meaning, if a6>a5 and a5>a4 and a4>a3 then a6/a3, if
a5>a4 and a4>a3, then a5/a3, etc.

How can I do this??
Thanks!

 

[Guest]

=IF(AND(A6>A5,A5>A4),A6/A3,otherwise)

 

[PCLIVE]

Try something like this:

=IF(AND(A6<A5,A5<A4,A4<A3),A6/A$3,)

After the comma at the end is what you want to return if the equation is
false.

HTH,
Paul