expanding IF  
Author Message
Fired





PostPosted: Fri May 07 06:48:33 CDT 2004 Top

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

Excel171  
 
 
Jerry





PostPosted: Fri May 07 06:48:33 CDT 2004 Top

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.