Why do you need an IF statement. Enter the number as a negative. Sum them. 1 plus -1 equals 0.
On Tue, Jun 29, 2010 at 12:05 PM, John Aldrich <[email protected] > wrote: > 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… > > > > [image: John-Aldrich][image: Tile-Tools] > > > > > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
<<image002.jpg>>
<<image001.jpg>>
