Thanks for your reply Dave
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
__________________
Achilles
-----Being unable to assume an initial premise with any tolerable degree of accuracy, I am loathe to assert a conclusion, fearful lest I should err.
|