Thread
:
Roundup to .99 endings
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
[email protected]
Posts: n/a
Roundup to .99 endings
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
=INT(price) + 0.99
That will change $20 to $20.99. Is that what you want?
Reply With Quote