Custom format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Use conditional format. Select Formula Is (not cell value is) then put round
function in the formula.
 
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.
 
Back
Top