Subtractic cells only with values

I want to subtract two cells in excel but only if both cells have a value. More exactly in this case C1 is currently =SUM(A1-B1), where A1 is my selling price and B1 is my buying price. C1 (my earnings) should be blank if either A1 or B1 don’t have a value.

As it is now, I can have a value in A1 and empty B1 and it will show me the total ammount of A1 in C1, although I need these fields in column C to be empty when one of A or B is missing.


By: Carl

Leave a Reply

Your email address will not be published. Required fields are marked *