Conditional Statement with ANDs

S

Stephen

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!
 
P

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
 
Top