expanding IF
 

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.

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

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.