Why is 7 the magic number? (IF statements)
Posted by Fred Sayers on August 07, 2001 2:11 PM
I have a small problem, and would be REALLY gratefull if someone could show me the light.
This is using Excell 97.
I am using the IF command in a branching style to help me arrive at a final cost for something. Basically if the number (date) is higher or lower than a certain variable date then do this, or that... its also got to be compounding at a 5% increase every year.. The formula is great and relativly simple because once youve done one step, the rest just builds. The problem I am having is that if I would like to do more than 7 Nested IF statements, I cant because of that magic number.
I read a previous string about something similar about the formula being too long, and COUNTIF was suggested... however I am relativly new to all this and cant implement it into my formula, which is btw..
Please help me throw some light on this problem because its making things very tricky for me and I am sure there is a easier method of doing this!