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 i...
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.
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.
