If and Then
Yes -- use an alternate method. There is always a better alternative to
nesting a lot of Ifs. Vlookup is the most typical, but there are others.
And, once you employ them, they are easier to use and debug.
Explain what problem you are trying to solve, and someone will come up with
a nifty solution.
Regards,
Fred.
"J" wrote in message
...
Does someone know how to increase the levels of nesting that will be
allowed
in excel? Currently it's 8 levels.
|