I need to write a very long If statement in an excel sheet (35 to be exact), and I can't figure out how.?

Question

I have been researching stuff on the internet, namely VB code among other things, but I am not sure which would be the easiest way to go about doing this. I have very limited experience with VB (decent knowledge of C++) and don't really know how to implement the code into the excel file. If someone could help me, it would be greatly appreciated. Thanks

Answer 1

hmm..tricky to answer with out knowing what the if statement entails..maybe using a select case statement might be better, but again..knowing what is required would help.
Can you clarify this some more.

Answer 2

Create a user defined function (UDF) in excel. This way you would run into characters limits than if you do it in the cell itself.
Download smart indenter so it indent for you properly.
Since you know C++, try not to do nested as it is hard to read.
Use case or elseifs constructs.
The only problem with UDFs is the slow calculation. You may have to force calculates to get the right answers if you have lots of UDFs.

Another alternative is to explore the use of vlookups functions. Probably you'll only need this.

Answer 3

It is not clear what you are referring to when you say "35."

An Excel formula can have a maximum of 1024 characters.

The maximum nested levels within an IF statement, or any other function(s), is 7. If you think you need 35 nested levels, there may be another way to get the result you want.

Please post additional details, if this hasn't answered your question.

Answer 4

Ah, the twisted common sense of activities information. For the sub to get the sparkling sheet no longer regularly looks honest, exceptionally if he performed in trouble-free terms a constrained nunber of minutes. It strikes me that with a view to get the credit for the shutout, the keeper needs to play a particular minimum time (60 minutes looks life like). evaluate baseball stats: with the intention to be credited with a win, a starting up pitcher ought to play a minimum of 5 (of 9) innings and be optimum at the same time as replaced. A sub coming in to close the game receives credited with a "keep", so both pitchers come away with some thing. except "keep" will be a confusing call for a goalkeeping stat.

Answer 5

When I get a very long If statement that can get confusing, I write small portions of the Final result in seperate cells. Get each portion of the final product working on it's own. When you get the proper results from each portion, then type it all out together in 1 cell.