THis seems to work fairly well. I'm not sure it's necessarily
generalizable for other numbers of cells:

A1: 22.05
A2: =ROUND(A1/8,2)
A3: =ROUND(-SUM(-$A$1,$A$2:A2)/(10-ROW()),2)

Copy A3 down to A9

In article ,
"Allison" wrote:

That's close to what I was looking for. Instead of having the last cell just
being what's left though, I'd like to have the cells distributed as evenly as
possible. For example, using the $22.05 from before, I'd like to end up with
5 cells that say $2.76 and 3 that say $2.75. Is that possible?