Forum Discussion
Formula Question
I want the words "Profit" "LOSS" or "Break Even" to appear in a cell (C42) depending on the sum of another cell (E42). The problem I am having is, E42 has a formula in it for the sum of different ce...
In cell C42 input...
=IF(E42=0,"Break Even",IF(E42>0,"Profit","LOSS"))
You can learn more about IF here...
https://support.office.com/en-us/article/IF-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2
Thank you so much!!!
