You are here:
- Home
- Computing/Technology
- Business Software
- Excel
- If Then Statement in excel 2003 with more than 7 functions
Excel/If Then Statement in excel 2003 with more than 7 functions
Advertisement
Question
Hey there! I am trying to make a long if then statement for a spread sheet I am creating. I have been teaching my self the required excel skills as a I go with the help of this and other sites. However, I have hit an impass, the nested function 7 level rule. If this rule was not the case for the version of excel that I must use my function would look like this;
=IF(I5=1,0.00,IF(I5=2,0.05,IF(I5=3,0.1,IF(I5=4,0.05,IF(I5=5,0.05,IF(I5=6,0.05,IF(I5=7,0.05,IF(I5=8,0.0775,IF(I5=8,0.053,IF(I5=9,0.05,IF(I5=10,0.04,IF(I5=11,0.05,IF(I5=12,0.08,IF(I5=13,0.027,IF(I5=14,0.04,))))))))))))))
How can I get around this? Im sure there is a way but I have yet to find a clear explanation. Thanks in advance for any help...
Ben,
Assume that you want to put your solution in cell "A1". You can break up your if statement among several cells as follows:
Cell Formula
"A1" =IF(I5=1,0,IF(I5=2,0.05,IF(I5=3,0.1,IF(I5=4,0.05,IF(I5=5,0.05,IF(I5=6,0.05,A2))))))
"A2" =IF(I5=7,0.05,IF(I5=8,0.0775,IF(I5=8,0.053,IF(I5=9,0.05,IF(I5=10,0.04,IF(I5=11,0.05,A3))))))
"A3" =IF(I5=12,0.08,IF(I5=13,0.027,IF(I5=14,0.04,A4)))
"A4" "N/A"
I added the "N/A" in cell "A4" so that if the value does not match to the data in "I5" the if statements all still work.
- Add to this Answer
- Ask a Question
| Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 8 | Politeness = 10 |
| Comment | At first I was limited in the use of his response but that was due to my lack of expertise with excel. However I got it working now and he was right on the money. Thanks a million! | ||
Related Articles
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Philip Buckley
Expertise
In Excel 2003 I can handle all basic questions such as how to copy and paste, all medium type questions such as pivot tables, and also am proficient in basic macros. I am also quickly learning 2007 where everything is pretty much the same but all in different places. Please be as detailed in writing your question as possible as that goes a long way in my ability to give the best answer possible.
Experience
I have 20 years of business experience, mostly in the area of finance and business consulting. Currently I am a Senior Business Consultant with a small business consulting firm. As part of my daily activities, I regularly use Excel to help make small businesses more efficient.
Education/Credentials
MBA from the Crummer Graduate School of Business at Rollins College.
©2012 About.com, a part of The New York Times Company. All rights reserved.