M
mj99
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!
points....
20.34 = 20.99
38.75 = 38.99
thanks in advance!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=roundup(a1,0)-.01
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
J
joeu2004
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
=INT(price) + 0.99
That will change $20 to $20.99. Is that what you want?
J
joeu2004
Bob said:=roundup(a1,0)-.01
Caveat emptor: That changes $20 to $19.99. If that is what you want,
so be it.
D
daddylonglegs
Perhaps
=roundup(a1+.01,0)-.0
=roundup(a1+.01,0)-.0
J
joeu2004
daddylonglegs said: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!).