Nested Ifs, how many levels?

[JeffGrant]

Hi All,

I am looking for some advice.

I have a Nested If statement, such is = If(logic, if true, If(logic, if true....... that is 25 levels deep and is likely to go another 5 levels.

Is there a better way of handling this?

 

[Michael M]

Well, there may be, but you haven't provided any useful information !

If(logic, if true, If(logic, if true..

tells us nothing.

 

[JeffGrant]

Well actually Michael, you have answered the question. By saying there maybe a better way indicates that there could be. That is all I was looking for. Thanks

 

[Michael M]

Hmmm, I was suggesting that there could be many and varied methods depending on what "if True" you are looking for.
If it's a table of data, it could be a LOOKUP, VLOOKUP,XLOOKUP oR INDEX?MATCH !!
It could Be a SUMPRODUCT as well....the list goes on .....hope you find your solution..