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 |
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 |