Show Monthly up to a point

[BeerBeer101]

calculating some deductions on a monthly basis...

So, i have a monthly salary - it varies depending on the number of pay periods... but for ease, let's go with 3500/month - $42,000 total..
i pay deductions on the first $38,999 - so looking for a simple formula to create a duplicate - but once it gets to $38,999 monthly - it shows zeros..
then i can do my deductions by month from there...

B3:M3 - those are hard numbers...
B10:M10 - that would be the formula to count the monthly and take only the balance - in this case December... note that some employee may hit the threshold in August - so Sept-Dec would present zero.

thanks for your input as always!

 

[BeerBeer101]

note: N10 is obviously going to report 38999 - not 42,000 - just forgot to change that in the example... thanks

 

[FormR]

Hi, here's one way to try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3			3500	3500	3500	3500	3500	3500	3500	3500	3500	3500	3500
4
5
6
7
8
9
10			3500	3500	3500	3500	3500	3500	3500	3500	3500	3500	499
Sheet1

Cell Formulas
Range	Formula
C10:M10	C10	=MAX(0,MIN(C3,38999-SUM($C3:C3)))