I want to subtract C21 from B21 if the amount in B21 is greater then the amount in C21 I want to sum to go into cell D21. if the amount in C21 is greater than the amount in B21 I want the sum to go into E21.
I was using the formula below. But it isn't working. What am I doing wrong?
=SUMIF(B21>C21)(B21-C21)
TIA
Luci
Bookmarks