Forum Discussion

Budwizer_10's avatar
Budwizer_10
Copper Contributor
Jul 15, 2021

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...
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 17, 2021

    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.

Budwizer_10's avatar
Budwizer_10
Copper Contributor
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. Greg
Budwizer_10's avatar
Budwizer_10
Copper Contributor
Jul 17, 2021
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?
    • Budwizer_10's avatar
      Budwizer_10
      Copper Contributor
      Jul 17, 2021
      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. thx

Resources