Conditional Statement with ANDs
 

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 a6a5 and a5a4 and a4a3 then a6/a3, if
a5a4 and a4a3, then a5/a3, etc.

How can I do this??
Thanks!
--
Thanks!

Stephen

=IF(AND(A6A5,A5A4),A6/A3,otherwise)

"Stephen" wrote:

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 a6a5 and a5a4 and a4a3 then a6/a3, if
a5a4 and a4a3, then a5/a3, etc.

How can I do this??
Thanks!
--
Thanks!

Stephen

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

"Stephen" wrote in message
...
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 a6a5 and a5a4 and a4a3 then a6/a3, if
a5a4 and a4a3, then a5/a3, etc.

How can I do this??
Thanks!
--
Thanks!

Stephen