M mj99 Jun 21, 2006 #1 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!
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!
B Bob Phillips Jun 21, 2006 #2 =roundup(a1,0)-.01 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=roundup(a1,0)-.01 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
J joeu2004 Jun 22, 2006 #3 mj99 said: Trying to get every number in an excel file to roundup for retail price points.... 20.34 = 20.99 38.75 = 38.99 Click to expand... =INT(price) + 0.99 That will change $20 to $20.99. Is that what you want?
mj99 said: Trying to get every number in an excel file to roundup for retail price points.... 20.34 = 20.99 38.75 = 38.99 Click to expand... =INT(price) + 0.99 That will change $20 to $20.99. Is that what you want?
J joeu2004 Jun 22, 2006 #4 Bob said: =roundup(a1,0)-.01 Click to expand... Caveat emptor: That changes $20 to $19.99. If that is what you want, so be it.
Bob said: =roundup(a1,0)-.01 Click to expand... Caveat emptor: That changes $20 to $19.99. If that is what you want, so be it.
J joeu2004 Jun 22, 2006 #6 daddylonglegs said: Perhaps =roundup(a1+.01,0)-.01 Click to expand... 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!).
daddylonglegs said: Perhaps =roundup(a1+.01,0)-.01 Click to expand... 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!).
