| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement with a range without a cell reference ie, #s 1100 to
=IF(G2=1200,12,IF(G2=1100,11,IF(G2=1000,10,IF(G2=6 00,6,""))))
I am trying to get the statement to calculate the numbers between 1100 and 1199; 1000 and 1999, and 600 thru 999. That if a number is put into cell g2 that is between 1100 and 1199, 11 will be in cell d. It won't take the range without having a cell reference. -- Dorothy J |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statement with a range without a cell reference ie, #s 1100 to
assuming that G2 may contain uncertain number beyond your sample
=if(or(g21199,g2<600),"then what!",if(g2=1100,11,if(g2=1000,10,if(g2=600,6, "why?")))) -- ***** birds of the same feather flock together.. "Dorothy J" wrote: =IF(G2=1200,12,IF(G2=1100,11,IF(G2=1000,10,IF(G2=6 00,6,"")))) I am trying to get the statement to calculate the numbers between 1100 and 1199; 1000 and 1999, and 600 thru 999. That if a number is put into cell g2 that is between 1100 and 1199, 11 will be in cell d. It won't take the range without having a cell reference. -- Dorothy J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - copy absolute cell references (within the range) as relati | Excel Discussion (Misc queries) | |||
| Cell reference in a range | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| use a cell to reference a range in a vlookup | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
