Thread: If and Then
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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.