Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Advanced MS Excel Programming question?
Excel is limited to 7 "if / then" statements in 1 cell.
More important:
You can't say:
in cell A1 = "if box A2 = 1, then make box A7 = 5"
you can only change the value of the box you are writing in.
(like I said, advanced excel programming)
Question:
is there ANY programs like Excel that is NOT limited in these ways?
or do I have to learn to program?
4 Answers
- AnalProgrammerLv 71 decade agoFavorite Answer
MS Excel has Visual Basic capabilities.
You will need to add a button or some other object to trigger the macro. Then the macro can test any number of values in any combination of cells and also put any values into any cells.
- 1 decade ago
1. Why not put the IF test directly into cell A7 instead of A1?
e.g =IF(A2=1,5,"")
2. If the 7 IF statements are too limiting, try a LOOKUP table with which you can have a large number of conditions depending upon the size of the table.
- 1 decade ago
From your example that you've used, you have written the formula on cell A1. But if you want to instead make A7 as 5, then why not write the formula on A7 itself, eg. in A7 the formula would be "=if(a2=1,5,0)
Maybe if you gave us the exact thing you need to do, we could be more specific on the answer?
- 1 decade ago
I do not know if there are any other programs like excel, there may be, but I would just deal with it and learn the rules.
Source(s): A couple 300 level classes
