Split an amount evenly with condition

[JustM3]

Hello,

I'm trying for a while to do an excel that splits an amount of money imputed for every month evenly between the employees but with a condition of 1/2 for the last two. I would be more than grateful for any ideas.

Thanks a lot.

JustM3-excel.xlsx

[alansidman]

See attached.

[JustM3]

thank you martin I'm not that familiar with excel i would be more than grateful if you could tell me where to put this condition. many thanks

[martindwilson]

=IF(ROWS($A$1:A1)>11,D$15/24,D$15/12) will do it for your example
but more generic
=IF(ROWS($A$1:A1)<COUNTA($A$2:$A$200)-1,D$15/(COUNTA($A$2:$A$20)-1),D$15/(2*(COUNTA($A$2:$A$20)-1))) where d15 is where the value is

[JustM3]

thanks a lot for the fast reply. One question though, for the values of the last two, is it possible to be exactly half of the value of the others? For example if the other ones are getting 18, the last two to get 9 each. Hope it makes sense.

many thanks

[martindwilson]

both ways i suggested here

[JustM3]

wow ure a star! thank you :D