round up (ends with...) (resolved)
For others that might be interested:
A1 = 16.99
=CEILING(A1*1.04+0.01,1)-0.01
--
Biff
Microsoft Excel MVP
"jatman" wrote in message
...
i got it figured out.
"jatman" wrote:
i need something that will round as follows:
OLD NEW
16.99 =16.99*1.04
result is as follows:
OLD NEW
16.99 17.67
what i need is the 17.67 to round up to 17.99
basically the old price (16.99, or whatever it is) multiplied with the
markup (4%, in this case is 17.67) and "rounded" up to the next .99.
(16.99
- 17.67 - 17.99)
i've seen some rounding examples, but i cannot figure this out, any help
is
appreciated.
thank you,
jat
|