ExcelBanter - round up cells to $xx.99

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - round up cells to $xx.99 (https://www.excelbanter.com/excel-worksheet-functions/20103-round-up-cells-%24xx-99-a.html)

RVV

round up cells to $xx.99

i have cells that i would like to round up to $xx.99 --- $0.30 = $0.99,
$3.44 = $3.99, $227.59 = $227.99

how can i do this?

N Harkawat

=IF(A1<1,0.99,INT(A1)+0.99)
where A1 is the cell holding the $$

"RVV" wrote in message
...
i have cells that i would like to round up to $xx.99 --- $0.30 = $0.99,
$3.44 = $3.99, $227.59 = $227.99

how can i do this?

If your amounts are in Col A. In Col B you could use.
=ceiling(A1,1)-.01

"RVV" wrote:

i have cells that i would like to round up to $xx.99 --- $0.30 = $0.99,
$3.44 = $3.99, $227.59 = $227.99

how can i do this?

All times are GMT +1. The time now is 07:57 AM.