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.
Excel Programming >> expanding IF
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
> 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.