round up cells to $xx.99

[Guest]

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 $$

 

[Guest]

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