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

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

=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

2. how to combine and's with or's in a if statement

3. Using query results within Conditional Statement...sequenced conditional queries

4. using conditional statements in stored procedures to buld select statement

5. How do I do a conditional statement in a constant statement?

6. using conditional statement in stored prcodure to build select statement

7. Conditional statement based on active form

8. build an if statement with conditional parameters

9. Syntax for If then Conditional Statement

10. help with conditional statements

11. Conditional Statement Syntax

12. prepare a conditional (if) statement

14. Conditional Statement based on active control

15. Conditional Statements in a Form

3 post • Page:**1** of **1**