| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validated cells and IF statements | Excel Discussion (Misc queries) | |||
| How are empty cells referenced in Excel in IF statements? | Excel Worksheet Functions | |||
| Ignoring zero cells in IF statements | Excel Worksheet Functions | |||
| Averages that include cells with IF statements | Excel Worksheet Functions | |||
| IF Statements for 3 cells | Excel Discussion (Misc queries) | |||
Linear Mode
