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

Use conditional format. Select Formula Is (not cell value is) then put round
function in the formula.



"maryj" wrote:

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

Thanks, but that did not work. We don't want to format the font or cell and
there is no option for custom number formats.
--
maryj


"Joel" wrote:

Use conditional format. Select Formula Is (not cell value is) then put round
function in the formula.



"maryj" wrote:

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