round up (ends with...)

[jatman]

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

 

[jatman]

i got it figured out.

 

[T. Valko]

For others that might be interested:

A1 = 16.99

=CEILING(A1*1.04+0.01,1)-0.01

 

[Teethless mama]

=ROUNDUP(A1*1.04,)-0.01