jaydeebetoo
Technical User
I have done this with nested ifs but i want more than seven possibilities. Can anyone tell me which function/feature i might use to achieve this?
many thanks
jdb
many thanks
jdb
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
auto fill cells based on one other cell value 1
- Thread starter jaydeebetoo
- Start date
- Status
-
1
- #2
You can utilise non nested IF statements such as
=IF(A1="Y","Test1","") & IF(A1="N","Test2","") & IF... etc etc
there is no limit except for formulae length
Other than that, it really depends on the type of data you are testing. If it is numeric, you might be able to use CHOOSE but you will need to provide more info to get a better answer...
Rgds, Geoff
"Three things are certain: Death, taxes and lost data. Guess which has occurred"
Please read FAQ222-2244 before you ask a question
=IF(A1="Y","Test1","") & IF(A1="N","Test2","") & IF... etc etc
there is no limit except for formulae length
Other than that, it really depends on the type of data you are testing. If it is numeric, you might be able to use CHOOSE but you will need to provide more info to get a better answer...
Rgds, Geoff
"Three things are certain: Death, taxes and lost data. Guess which has occurred"
Please read FAQ222-2244 before you ask a question
- Status
Similar threads
- Locked
- Question