View Single Post
  #1   Report Post  
Allison
 
Posts: n/a
Default Rounding up for down based on cell value

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?