2 IF statements looking at two cells
 

We have 3 machine ring sizes, each with a maximum dimension for a box inside.
So for the 1800 ring, the maximum width is 1200, max length is 1400. If
either the width or length exceed these, we need to specify the next size,
2300.

We have width in cell G38 Length in cell G37.
=IF(G38<1201,"1800",IF(G38<1701,"2300", IF(G38<2200,"2800",))) puts
1800/2300/2800 in cell M25
=IF(G37<1401,"1800",IF(G37<1901,"2300", IF(G37<2550,"2800",))) puts
1800/2300/2800 in cell M26

Is there a way of combining these two so that the result from both will be
in one cell? Then if EITHER G38 is 1201-1701 or G37 is 1401 - 1901 the result
is 2300 etc etc.

Thanks,
Andy

2 IF statements looking at two cells
 

=if(or(G38=2200,G37=2550),"?",if(or(G38=1701,G3 7=1901),"2800",if(or(G38=1201,G37=1401),"2300", "1800")))

"AndyB" wrote:

We have 3 machine ring sizes, each with a maximum dimension for a box inside.
So for the 1800 ring, the maximum width is 1200, max length is 1400. If
either the width or length exceed these, we need to specify the next size,
2300.

We have width in cell G38 Length in cell G37.
=IF(G38<1201,"1800",IF(G38<1701,"2300", IF(G38<2200,"2800",))) puts
1800/2300/2800 in cell M25
=IF(G37<1401,"1800",IF(G37<1901,"2300", IF(G37<2550,"2800",))) puts
1800/2300/2800 in cell M26

Is there a way of combining these two so that the result from both will be
in one cell? Then if EITHER G38 is 1201-1701 or G37 is 1401 - 1901 the result
is 2300 etc etc.

Thanks,
Andy

2 IF statements looking at two cells
 

100% and a quick reply
Thanks.
Andy


"bj" wrote:

=if(or(G38=2200,G37=2550),"?",if(or(G38=1701,G3 7=1901),"2800",if(or(G38=1201,G37=1401),"2300", "1800")))

"AndyB" wrote:

We have 3 machine ring sizes, each with a maximum dimension for a box inside.
So for the 1800 ring, the maximum width is 1200, max length is 1400. If
either the width or length exceed these, we need to specify the next size,
2300.

We have width in cell G38 Length in cell G37.
=IF(G38<1201,"1800",IF(G38<1701,"2300", IF(G38<2200,"2800",))) puts
1800/2300/2800 in cell M25
=IF(G37<1401,"1800",IF(G37<1901,"2300", IF(G37<2550,"2800",))) puts
1800/2300/2800 in cell M26

Is there a way of combining these two so that the result from both will be
in one cell? Then if EITHER G38 is 1201-1701 or G37 is 1401 - 1901 the result
is 2300 etc etc.

Thanks,
Andy