This morning, I have to do something (simple calculations) in excel *sigh* documents. I have to append data, and make adjustment to some formulas I have created before. The formula contains a series of nested IFs. It was made by me as a quick and dirty solution, without really thinking about future usage of the document or formula.
Apparently, as more data being inserted and I add more columns to check with the IF, excel keeps telling me that my formula is wrong. I tried to change it several times, triple check the parentheses, and retype the formula from scratch. I was frustrated, am I that stupid and can't get a stupid IF formula to work. In frustration, I search for enlightenment to Google. As I typed "nested if excel formula", the first hit excerpt shows that there are limitations.
A well known limitation to Excel is that you cannot "nest more than 7 functions
What? Excel only support SEVEN nested IF functions? What kind of limitation is that? Is it that difficult to make it support 8, or 10, or 100, or unlimited?
I don't want to know why they choose 7. I don't care. I'll live with 7 nested IF, just like everyone else. Thanks to excel, now I have to rewrite all my formulas in this file. Not that it's difficult to do. It's just a waste of time. Good stuff excel.
*I wonder whether OpenOffice and iWork Numbers have this limitation too*
Comments [1]