Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if functions with more than 7 ifs (ranges are possible?)
ok in one cell that i have there could be a possibility of 1-14 and i want
for example if i enter 1 or 2 in another cell it will come up 0, then for 3 or 4 or 5 it to come up 1, then for 6 or 7 or 8 or 9 it to come up 2. Is this at all possible because i can't seem to get it to work |
#2
|
|||
|
|||
hi irwinko,
ok in one cell that i have there could be a possibility of 1-14 and i want for example if i enter 1 or 2 in another cell it will come up 0, then for 3 or 4 or 5 it to come up 1, then for 6 or 7 or 8 or 9 it to come up 2. Is this at all possible because i can't seem to get it to work this is by design. use vlookup instead. see help for details. arno |
#3
|
|||
|
|||
=IF(AND(A1=1,A1<=2),0,IF(AND(A1=3,A1<=5),1,IF(AN D(A1=6,A1<=9),2,3)))
- Mangesh "irwinko" wrote in message ... ok in one cell that i have there could be a possibility of 1-14 and i want for example if i enter 1 or 2 in another cell it will come up 0, then for 3 or 4 or 5 it to come up 1, then for 6 or 7 or 8 or 9 it to come up 2. Is this at all possible because i can't seem to get it to work |
#4
|
|||
|
|||
=CHOOSE(A1,0,0,1,1,1,2,2,2,3,3,3,4,4,4)
where A1 is the cell with the # 1-14 "irwinko" wrote: ok in one cell that i have there could be a possibility of 1-14 and i want for example if i enter 1 or 2 in another cell it will come up 0, then for 3 or 4 or 5 it to come up 1, then for 6 or 7 or 8 or 9 it to come up 2. Is this at all possible because i can't seem to get it to work |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions | |||
Problem with graph ranges | Charts and Charting in Excel | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |