# formula problem

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Can you give an example (maybe hardcoded) of the results you are expecting?

Oaktree,

what I am expecting to come out would be the following. After year 5 my initial number of animals 300 would have depreciated to about 272, taking the yearly mortality of 2% into account. So in year 6 these get taken to the slaughterhouse. After year 8 the heifers born in year 1 should be going to the slaughterhouse since they have now been reproducing for 5yrs. in year 9, the animals born in year 2 go to the slaughterhouse and so on...

Not too sure, but maybe:

C28 =(C27+F25)-(C22*(1-\$C\$15)^5)-((C27-(C22*(1-\$C\$15)^5))*C\$15)

C29 =(C28+F26)-(C23*(1-\$C\$15)^5)-((C28-(C23*(1-\$C\$15)^5))*C\$15)-(F22*(1-\$C\$15)^7)

Replies
1
Views
234
Replies
4
Views
159
Replies
1
Views
109
Replies
17
Views
408
Replies
0
Views
234

1,220,978
Messages
6,157,180
Members
451,402
Latest member
Lyv

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back