Roundup to .99 endings
 

Trying to get every number in an excel file to roundup for retail price
points....

20.34 = 20.99
38.75 = 38.99

thanks in advance!


--
mj99
------------------------------------------------------------------------
mj99's Profile: http://www.excelforum.com/member.php...o&userid=35647
View this thread: http://www.excelforum.com/showthread...hreadid=554321

Roundup to .99 endings
 

=roundup(a1,0)-.01

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mj99" wrote in message
...

Trying to get every number in an excel file to roundup for retail price
points....

20.34 = 20.99
38.75 = 38.99

thanks in advance!


--
mj99
------------------------------------------------------------------------
mj99's Profile:
http://www.excelforum.com/member.php...o&userid=35647
View this thread: http://www.excelforum.com/showthread...hreadid=554321

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?

Roundup to .99 endings
 

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.

Roundup to .99 endings
 

Perhaps

=roundup(a1+.01,0)-.01


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=554321

Roundup to .99 endings
 

daddylonglegs wrote:
Perhaps
=roundup(a1+.01,0)-.01

Killing an ant with a sledgehammer. I believe that has the same result
as INT(price) + 0.99, at least for all positive numbers (prices!).