Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Client is using Solver. She would like a custom format to format the cells
that change to round up to the nearest .05. For example, 1.26 would round to 1.3 and 1.31 would round to 1.35. We can't directly use a round function on the changing cells because it would create a circular reference. We could have the changing cells be in one area of the sheet and use the round function to round those cells. But, is there any way to round with a custom format? -- maryj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
custom format or conditional format? | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
custom format | Excel Worksheet Functions |