Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to jump to another formula in another cell
depending on the result of one cells IF ? I'm looking for a way to include many different choices depending on many different scenarios, kinda like the C language switch case: statements. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not sure what you are asking.
A cell formula (or a VBA function called from a cell) cannot change the selected cell. =IF(condition,cell1,cell2) can return the contents of different cells. If the issue is that you need more choices than you can handle with Excel's limit of 7 nested function, consider replacing the IF statment with either a =VLOOKUP() formula or a VBA user defined function (which has a Select Case structure). Jerry D wrote: Is there a way to jump to another formula in another cell depending on the result of one cells IF ? I'm looking for a way to include many different choices depending on many different scenarios, kinda like the C language switch case: statements. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
expanding a macro to do more | Excel Discussion (Misc queries) | |||
Expanding on a formula | Excel Worksheet Functions | |||
Expanding and Collapsing | Excel Discussion (Misc queries) | |||
Expanding data | Excel Worksheet Functions | |||
Expanding Code | Excel Programming |