one way, if I understand you correctly:

A1: 22.05
A2: =ROUND(A1/8,2)
A3-A8: =A$2
A9: =A1-SUM(A2:A8)


In article ,
"Allison" wrote:

I'd like to be able to enter a dollar amount (say A1 = $22.05) and then have
8 cells display dollar amounts that add up to A1. Is there a function that
would round up or down the correct number of cells (to two decimal places) to
equal $22.05?