Forum Discussion
Solved
Excel (SWITCH function?)
I wish to show a description next to a couple of sub-totals (e.g let us say that the sub-totals are in cells G50 & H50). I want the description in, say, cell D50 to show the wording "Profit" or "Loss...
- Hans
Thanks, that looks neat - I will try it!
If you want a recent function
= SWITCH(
SUM((values>0)*{2,1}),
3, "Profit",
2, "Profit/(Loss)",
1, "(Loss)/Profit",
"(Loss)"
)