IF January starts in A1 the first input number in cell B1 then cell C1 would have:

=IF(B1>1410000,B1*1.8,IF(B1>1100000,B1*1.65,IF(B1>0,B1*1.5,"")))

C2:

=IF(B1+B2>1410000,B2*1.8,IF(B1+B2>1100000,B2*1.65,IF(B1+B2>0,B2*1.5,"")))

C3:

=IF(SUM(B1:B3)>1410000,B3*1.8,IF(SUM(B1:B3)>1100000,B3*1.65,IF(SUM(B1:B3)>0,B3*1.5,"")))

C4:

=IF(SUM(B1:B4)>1410000,B4*1.8,IF(SUM(B1:B4)>1100000,B4*1.65,IF(SUM(B1:B4)>0,B4*1.5,"")))

C5:

=IF(SUM(B1:B5)>1410000,B5*1.8,IF(SUM(B1:B5)>1100000,B5*1.65,IF(SUM(B1:B5)>0,B5*1.5,"")))

C6:

=IF(SUM(B1:B6)>1410000,B6*1.8,IF(SUM(B1:B6)>1100000,B6*1.65,IF(SUM(B1:B6)>0,B6*1.5,"")))

C7:

=IF(SUM(B1:B7)>1410000,B7*1.8,IF(SUM(B1:B7)>1100000,B7*1.65,IF(SUM(B1:B7)>0,B7*1.5,"")))

C8:

=IF(SUM(B1:B8)>1410000,B8*1.8,IF(SUM(B1:B8)>1100000,B8*1.65,IF(SUM(B1:B8)>0,B8*1.5,"")))

C9:

=IF(SUM(B1:B9)>1410000,B9*1.8,IF(SUM(B1:B9)>1100000,B9*1.65,IF(SUM(B1:B9)>0,B9*1.5,"")))

C10:

=IF(SUM(B1:B10)>1410000,B10*1.8,IF(SUM(B1:B10)>1100000,B10*1.65,IF(SUM(B1:B10)>0,B10*1.5,"")))

C11:

=IF(SUM(B1:B11)>1410000,B11*1.8,IF(SUM(B1:B11)>1100000,B11*1.65,IF(SUM(B1:B11)>0,B11*1.5,"")))

C12:

=IF(SUM(B1:B12)>1410000,B12*1.8,IF(SUM(B1:B12)>1100000,B12*1.65,IF(SUM(B1:B12)>0,B12*1.5,"")))

Thanks

Ken

I haven't checked whether or not the formula works, but assuming it does, it is not necessary to have 12 different formulas. Just put the following in C1 and drag it down :-

=IF(SUM($B$1:B1)>1410000,B1*1.8,IF(SUM($B$1:B1)>1100000,B1*1.65,IF(SUM($B$1:B1)>0,B1*1.5,"")))

Lars --

What should be the result(s) if we have the following entries?

{"Jan",150000;

"Feb",200000;

"Mar",650000;

"Apr",100000;

"May",350000;

"Jun","";

"Jul","";

"Aug","";

"Sep","";

"Oct","";

"Nov","";

"Dec",""}

Aladin

===========