Forum Discussion
Solved
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.
Budwizer_10 Who's spreadsheet are you referring to? Easier if you upload your schedule so that either PeterBartholomew1 or I can help you out.
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
- Riny_van_Eekelen, I truly want to thank for your help, it works great and you have given me a better understanding of excel.
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.