Conditional Sum

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

MS Office 2000, Windows 2000

contents of Feb!A2 are the result of a calculation of Jan!
A2-Jan!A34
contents of Feb!A3 are the result of a calculation of Jan
B2-Jan!B35

and so on and so on for sheets Jan thru Dec

If Feb!A2 < 0 need to have cell contents of Feb!A2 appear
as 0 (zero) and to subtract A2 from A3

A2 B2
5 4 nothing would happen as A2>0
-1 4 need A2 to appear as 0 and B2 to appear as 3
 
Hi Cheryl
not quite sure but try the following:
For A2:
=MIN(your_existing_formula_A2,0)

For B2:
=IF(your_existing_formula_A2,your_existing_formula_B2-your_existing_for
mula_A2,your_existing_formula_B2)
 
Back
Top