expanding IF

  • Thread starter Thread starter D
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Variable Range Copy... 13
Macro 2 insert formula if part of cell contains specific text 5
A data validation question 1
Referencing data validation list in IF Statement 2
Nested if....? 5
Runtime error 1004 when trying to insert formula in cells 11
collapse an expand rows using VB 7

Back
Top