If statement help needed!

[cfrobw]

Background

I have a a few diagrams that I print on a 4"x6" label to use as a reference for cutting and scoring a 60" x 90" Cardboard blank in to custom size boxes.

I figured out how to make it say that the if the dimensions are to large it will display "too large for a one sheet box" like the following.

=IF(AND(A3>60,O14>90),"TOO LARGE FOR ONE SHEET","") A3 is the Total Width and O14 is the total Length.

Now its possible for the item to be boxed is wider then A3, If it is, it is possible to rotate the diagram and print it with numbers in a different location. This will work as long as the width A3 is greater than (A3>60) but the width A3 is less than or equal to 90 (A3<=90) and the length O14 is less than or equal (014<=60). If this criteria is met the user must be told to use a rotated diagram.

So I'm trying to put this into a statement that will do three things.

1. If (A3<=60) and (O14 <= 90) Display ""
1 Sheet Box.png

2. If (A3>60) and (A3<=90) and (O14 <=60) Display "USE ROTATED DIAGRAM"
Which means the user must select this worksheet to print.
1 Sheet Box Rotated.png

3. If (A3>60) and (O14>90) Display "TOO LARGE FOR 1 SHEET BOX"
1 Sheet Box Too Large.png
Which means the user must select this worksheet with the two sheet box diagram to print
2 sheet box.png

I'd like to do this in a nested if statement. I know basics of excel and I know how to use IBM BASIC and Microsoft GW BASIC, but I cant figure out the excel spreadsheet syntax.
Any help would be greatly appreciated!

Thanks!

Rob

[Craig K.]

Just based on the three conditions you provided you would write it like this

=IF(AND(A3<=60,O14<=90),"",IF(AND(A3>60,A3<=90,O14<=60),"USE ROTATED DIAGRAM",IF(AND(A3>60,O14>90),"TOO LARGE FOR 1 SHEET BOX","Incompatible Measurements")))

I'm assuming that if any measurements fall outside of the three ranges you gave they would be considered "incompatible measurements" such as if A3<60 and O14>90