I've got a spreadsheet I update once a month for one of our sales managers. What it shows is the sales for the previous month, the sales for year-to-date, the sales for the same period last year and the sales for the year-to-date last year. Sometimes one of the numbers is a negative number (i.e. if we had to bring the carpet back due to a defect or something.) I've got it working partially, but sometimes the math doesn't seem to work. How would I go about writing my formula to test whether either number in a matched set (i.e. last month and the same period last year) are negative and then either add or subtract based on which number is negative?
Here's the current formula: =IF(C148<0,C148+G148,C148-G148) I'd like to test to see if G148 is negative (in this case, it is) and if C148 is negative (in this case it is NOT.) Sometimes both will be negative, sometimes one will be negative. I want to do the math properly depending on which is negative. There are cases where it is pretty obviously NOT working correctly, but I'm not sure how to correct the formula. Thanks. John-AldrichTile-Tools ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
<<image001.jpg>>
<<image002.jpg>>
