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