Formula Question

Copper Contributor

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 cells and dollar amounts. Can anyone help with this formula?

2 Replies

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!!!