Quote:
Originally Posted by Achilles
I did it by using MAX(0,J2) to create a duplicate column of figs that I could plug into a formula in another column. Your formula seems pretty slick, like I could plug it right into the formula and avoid creating a redundant column. I'll give that a try later.
Thanks again for answering.................Jack
|
Why not just plug MAX(0,J2) into the formula itself so you don't have to create another column?