Forum Discussion
Mutiple formulas in 1 cell
how do you write mutilple formulas for 1 cell. example (in one cell if the number is 5 then i want it to input in another cell the number 1 OR if the number in that same cell is 4 then i want it to input in another cell the number 2 and so on.
Budwizer_10 OK, you went for a horizontal lookup table. Not sure if you can work with the newer functions so I added the "old-style" formulae, after changing the lookup table a bit. See attached.
15 Replies
Spreadsheets provide a functional, rather than imperative, programming style. That means they are specifically designed to prevent a value/cell being changed as a result of executing one or more instructions held elsewhere.
Rather than looking at the value in a cell and thinking "What do I want to happen as a result of this?", focus on the other cells and ask "How do I determine the value of this cell"
- Hi there, thanks so much for the response. Here is a copy of what i am trying to do.
This table is for a golf game and basically on hole 1 if par is a 4 and Greg scores a 6 he should get 0 points, if he scores a 5 he should get 1 point and he scores a 4 then 2 points and if he scores a 3 then gets 3 points. I am trying to input the mutiple what if formula into where the Points total (1) is and retreive the data from where Greg inputs his score (5)
Hole 1 Hole 2 Hole 3 .........etc
Par 4 5 3
Greg 5 4 4
Points 1
Not sure if this is possible but any further help would be very much appreciated.
Budwizer_10 A cell can only hold one formula, but it can have many different outcomes. On the other hand, multiple formulae can reference one particular cell.
If you could upload a schedule that gives a clear example of what you are dealing with, that would be helpful.
- Hi there, thanks so much for the response. Here is a copy of what i am trying to do.
This table is for a golf game and basically on hole 1 if par is a 4 and Greg scores a 6 he should get 0 points, if he scores a 5 he should get 1 point and he scores a 4 then 2 points and if he scores a 3 then gets 3 points. I am trying to input the mutiple what if formula into where the Points total (1) is and retreive the data from where Greg inputs his score (5)
Hole 1 Hole 2 Hole 3 .........etc
Par 4 5 3
Greg 5 4 4
Points 1
Not sure if this is possible but any further help would be very much appreciated.Budwizer_10 No problem. See attached workbook for a working example based on your description. But I suspect that your next question will be to include course rating, multiple players, stroke index, handicap and playing handicap.
In the attached file you'll find two solution. One with new Excel functions and one with an "old-style" approach.
