expanding IF

D

D

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.
 
J

Jim Rech

Besides the IF function there are the CHOOSE, VLOOKUP, INDEX and OFFSET
functions that can be used get results from different cells depending on
various conditions.

If you want full blown programming control you'd have to write your own
function in the VBE. With a UDF ("User defined function") you could include
a Select statement which is similar to C Case statements.

--
Jim Rech
Excel MVP
| 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.
|
|
 
Top