| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| 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
