Discussion Re: Mutiple formulas in 1 cell in Excel
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2562350#M107285
Riny_van_Eekelen, I truly want to thank for your help, it works great and you have given me a better understanding of excel.Mon, 19 Jul 2021 13:56:58 GMTBudwizer_102021-07-19T13:56:58ZMutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2553267#M106907
<P>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.</P>Thu, 15 Jul 2021 16:44:22 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2553267#M106907Budwizer_102021-07-15T16:44:22ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2554877#M106920
<P><LI-USER uid="1104591"></LI-USER> A cell can only hold <STRONG>one</STRONG> formula, but it can have many different outcomes. On the other hand, multiple formulae can reference one particular cell.</P><P> </P><P>If you could upload a schedule that gives a clear example of what you are dealing with, that would be helpful.</P>Fri, 16 Jul 2021 05:13:45 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2554877#M106920Riny_van_Eekelen2021-07-16T05:13:45ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2555212#M106930
<P><LI-USER uid="1104591"></LI-USER> </P><P>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.</P><P> </P><P>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"</P><P> </P>Fri, 16 Jul 2021 08:31:30 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2555212#M106930Peter Bartholomew2021-07-16T08:31:30ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2557894#M107012
Hi there, thanks so much for the response. Here is a copy of what i am trying to do.<BR />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)<BR />Hole 1 Hole 2 Hole 3 .........etc<BR />Par 4 5 3<BR />Greg 5 4 4<BR />Points 1<BR />Not sure if this is possible but any further help would be very much appreciated.<BR /><BR />Fri, 16 Jul 2021 23:09:42 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2557894#M107012Budwizer_102021-07-16T23:09:42ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2557895#M107013
Hi there, thanks so much for the response. Here is a copy of what i am trying to do.<BR />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)<BR />Hole 1 Hole 2 Hole 3 .........etc<BR />Par 4 5 3<BR />Greg 5 4 4<BR />Points 1<BR />Not sure if this is possible but any further help would be very much appreciated.Fri, 16 Jul 2021 23:10:43 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2557895#M107013Budwizer_102021-07-16T23:10:43ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558123#M107026
<P><LI-USER uid="1104591"></LI-USER> 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.</P><P> </P><P>In the attached file you'll find two solution. One with new Excel functions and one with an "old-style" approach.</P>Sat, 17 Jul 2021 04:46:46 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558123#M107026Riny_van_Eekelen2021-07-17T04:46:46ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558450#M107044
<P><LI-USER uid="403176"></LI-USER> </P><P>I liked the 365 solution! Since you have the situation under control, I set out to play with Lambda functions. I think it may be a while before I really get settled into the new ways of working and read the formulas fluently; they still don't look like spreadsheets to me.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 318px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/296562iE318E8A787022066/image-dimensions/318x280?v=v2" width="318" height="280" role="button" title="image.png" alt="image.png" /></span></P>Sat, 17 Jul 2021 11:05:24 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558450#M107044Peter Bartholomew2021-07-17T11:05:24ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558771#M107074
Riny/van/Eekelen, thank you so much this is what i was looking for and it now makes sense, what you are saying. Excel is unable to create a mutiple formula in one cell so you have to create a data table to draw from for all the what ifs. Again thank you so much. GregSat, 17 Jul 2021 14:41:38 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558771#M107074Budwizer_102021-07-17T14:41:38ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558772#M107075
Peter, I want to thank you also this gives me a better understanding of what i was looking for and it now makes sense, what you are saying. Excel is unable to create a mutiple formula in one cell so you have to create a data table to draw from for all the what ifs. Again thank you so much. GregSat, 17 Jul 2021 14:43:11 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558772#M107075Budwizer_102021-07-17T14:43:11ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558822#M107078
One last question, Your spreadsheet works perfect but when I try to copy paste the scores and points values for all of 1 player to create another player the formulas do not work any longer. Am i missing something in the copying and pasting?Sat, 17 Jul 2021 15:35:08 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558822#M107078Budwizer_102021-07-17T15:35:08ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558835#M107079
<P><LI-USER uid="1104591"></LI-USER> Who's spreadsheet are you referring to? Easier if you upload your schedule so that either <LI-USER uid="214174"></LI-USER> or I can help you out.</P>Sat, 17 Jul 2021 15:37:59 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558835#M107079Riny_van_Eekelen2021-07-17T15:37:59ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558871#M107081
Hi there, either yours or Peters i could not seem to copy paste to create another player. I am not sure how to upload a copy of mine otherwise i would. Where do i upload a copy. thxSat, 17 Jul 2021 15:42:58 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558871#M107081Budwizer_102021-07-17T15:42:58ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558876#M107082
<P><LI-USER uid="1104591"></LI-USER> </P>Sat, 17 Jul 2021 15:45:37 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558876#M107082Budwizer_102021-07-17T15:45:37ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558879#M107083
<P><LI-USER uid="1104591"></LI-USER> Below the box where you answer, you should see this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2021-07-17 at 17.44.06.png" style="width: 513px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/296568i6B92C8BB523B4F8A/image-size/large?v=v2&px=999" role="button" title="Screenshot 2021-07-17 at 17.44.06.png" alt="Screenshot 2021-07-17 at 17.44.06.png" /></span></P><P>Just follow the instructions <LI-EMOJI id="lia_slightly-smiling-face" title=":slightly_smiling_face:"></LI-EMOJI></P>Sat, 17 Jul 2021 15:46:38 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558879#M107083Riny_van_Eekelen2021-07-17T15:46:38ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558883#M107084
<P><LI-USER uid="1104591"></LI-USER> 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.</P>Sat, 17 Jul 2021 15:59:24 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2558883#M107084Riny_van_Eekelen2021-07-17T15:59:24ZRe: Mutiple formulas in 1 cell
https://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2562350#M107285
Riny_van_Eekelen, I truly want to thank for your help, it works great and you have given me a better understanding of excel.Mon, 19 Jul 2021 13:56:58 GMThttps://techcommunity.microsoft.com/t5/excel/mutiple-formulas-in-1-cell/m-p/2562350#M107285Budwizer_102021-07-19T13:56:58Z