| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
| Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Threaded Mode
