Columns (formatted as Currency):
A - B - C - D
- C= A+B
- D needs to display 1/2 (50%) of C IF C is a positive number.
- IF C is a negative number, D needs to display zero.
- Column D will be summed.
Columns (formatted as Currency):
A - B - C - D
In D1
:
=MAX(C1;0) / 2
Thank you. I had a Brain=null moment.