Column A: Purchase Price Column B: Shipping Price Column C: Marketing Price
I'm trying to check and see if A + B is greater than C so I can determine if I'm losing profit or not.
This is my formula, but the answer is not coming out correctly.
=if(sum(A2+B2)>C2, "You're not making any profit", "You're making profit")
The outcome is the total opposite. For example, if A2+B2 is greater than C2; it says I'm making profit which isn't true. Correct me if I'm wrong, but the way I interpret my formula is:
if A2(1.50) + B2(.99) = (2.49) is greater than C2(1.10) then .... which 2.49 is greater than 1.10.