I do have a worksheet that calculates sales profits or losses quarterly in 3
different locations. For each quarter I do have a formula that gives me the
increase or decrease amounts during the last couple of years. For the total
result I need a formula that converts or ignores the negative results. Any
calculation result with a minus sign in the formula should be equal to zero,
so it's not included in the final quaterly total.
Could somebody help me with it? Thanks!