How do you SUM a range and ONLY multiply if the SUM of the range is a negative number and have it return an absolute value of the final number other wise return a 0 if the SUM of the range is a positive number?
=0.15*SUM(B10:R10)
is what I have started out on, but not sure how to proceed.
Bookmarks