I need help with a formula

[jgrant78]

This is what I am tring to do. I want to take a number..say 1000 and subtract 200 from it and if the answer is >200 put 200 in that cell, But i want the remainder of 800 to move into the cell infront of that one and repeat the process until 0 is reached. I know if,and statements are only good for the cell they are in so I will need a macro to do this?

please help

 

[jasonb75]

Doesn't need a macro.

Assuming 1000 entered in A1

In B1 =IF(A1>200,200,A1)

In C1 =A1-B1

Select B1 & C1 then use autofill to copy both formula 10 columns to the right

 

[Peter_SSs]

Could it be this? Formulas in A2 and B2 copied down.

Excel Workbook
	A	B
1	950
2	750	200
3	550	200
4	350	200
5	200	150
6	0	0
7	0	0
jgrant78

 

[jgrant78]

Im sorry but I didn't give enough information about what I am tring to do. I have a 52 week calender and I have projects that I want excel to put the number of hours I have available in each week until the hrs reach zero

ex. I have a project that is going to take 5500 hrs to complete. I have 980 hours per week to apply to this project. Say I need to have this done by week 30. So In week 30 I put 5500 hours and excel splits it up until it reaches zero.

So I want something that will do this no matter were I put it into the 52 week calender. Maybe I can still do this with an IF statement?

 

[Peter_SSs]

Perhaps then you could show us a small section of your calendar with some dummy Data & the results you would want? It's abit hard to suggest anything when you have no idea of layout and specific requirements.