Conditional Statement with ANDs

Conditional Statement with ANDs

Post by U3RlcGhlb » Wed, 13 Apr 2005 00:00:02


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

Stephen
 
 
 

Conditional Statement with ANDs

Post by RHVrZSBDYX » Wed, 13 Apr 2005 00:40:02

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

 
 
 

Conditional Statement with ANDs

Post by PCLIV » Wed, 13 Apr 2005 00:41:18

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