| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell formatting ends up scientific? | Excel Discussion (Misc queries) | |||
| filter using "ends with" and 3 choices? Ex: ends with 1,2 or3 | Excel Worksheet Functions | |||
| how do I delete a row automatically after each date ends | Excel Discussion (Misc queries) | |||
| Dynamically determining when a month ends | New Users to Excel | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
