View Single Post
  #3   Report Post  
PCLIVE
 
Posts: n/a
Default

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