Custom Functions

  • Thread starter Thread starter patrickbirch
  • Start date Start date
P

patrickbirch

Is it possible to write custom funtions that utilise a for next loop
when a cell is updated to recalculate a new figure. I can't use an if
statement as it would need to use more than seven nested statements.
 
One of the most oft abused functions is the IF statement, because people believe it should
be able to nest more than 7 deep, whereas the truth is that if you need that level of
nesting, you are probably using the wrong function to try and achieve your goal. There
are numerous other functions that are generally better at achieving things like this, such
as VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX & MATCH, OFFSET & MATCH, CHOOSE etc

As Andy said, give us some idea of what it is you are trying to do, and lets see if we
can't steer you in the right direction.
 
Back
Top