Custom Functions

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

Ken Wright

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