Formula for adding ONLY Positive Numbers

Columns (formatted as Currency):
A - B - C - D

  1. C= A+B
  2. D needs to display 1/2 (50%) of C IF C is a positive number.
  3. IF C is a negative number, D needs to display zero.
  4. Column D will be summed.

In D1:

=MAX(C1;0) / 2
2 Likes

Thank you. I had a Brain=null moment.