Forum Discussion
Nigel_Lewis570202
Sep 02, 2022Copper Contributor
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...
- Sep 02, 2022Hans
Thanks, that looks neat - I will try it!
HansVogelaar
Sep 02, 2022MVP
Alternatively
=IF(G50>0,IF(H50>0,"Profit","Profit/(Loss"),IF(H50>0,"(Loss)/Profit","Loss"))
Nigel_Lewis570202
Sep 02, 2022Copper Contributor
Hans
Thanks, that looks neat - I will try it!
Thanks, that looks neat - I will try it!