round up (ends with...)
 

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

round up (ends with...) (resolved)
 

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

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

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