Bob Phillips wrote:
"mj99" wrote:
Trying to get every number in an excel file to roundup for retail price
points....
20.34 = 20.99
38.75 = 38.99

=roundup(a1,0)-.01

Caveat emptor: That changes $20 to $19.99. If that is what you want,
so be it.