negative numbers to show as zero
Posted by Lori on October 03, 2001 11:49 AM
I am sure this should be simple. If I am subtracting two numbers and would like them to show the end result if positive but zero if they tally to negative. This is built within a number of if then statements, suggesting that if I add an additional if statement then I will have too many arguments in the formula. I was hoping there is a different approach that someone could show me.
Please & Thanks