round up (ends with...)
=ROUNDUP(A1*1.04,)-0.01
"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
|