| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Roundup to .99 endings
Trying to get every number in an excel file to roundup for retail price points.... 20.34 = 20.99 38.75 = 38.99 thanks in advance! -- mj99 ------------------------------------------------------------------------ mj99's Profile: http://www.excelforum.com/member.php...o&userid=35647 View this thread: http://www.excelforum.com/showthread...hreadid=554321 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Roundup to .99 endings
=roundup(a1,0)-.01
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mj99" wrote in message ... Trying to get every number in an excel file to roundup for retail price points.... 20.34 = 20.99 38.75 = 38.99 thanks in advance! -- mj99 ------------------------------------------------------------------------ mj99's Profile: http://www.excelforum.com/member.php...o&userid=35647 View this thread: http://www.excelforum.com/showthread...hreadid=554321 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Roundup to .99 endings
Bob Phillips wrote: "mj99" wrote: Trying to get every number in an excel file to roundup for retail price points.... 20.34 = 20.99 38.75 = 38.99 =roundup(a1,0)-.01 Caveat emptor: That changes $20 to $19.99. If that is what you want, so be it. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Roundup to .99 endings
Perhaps =roundup(a1+.01,0)-.01 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=554321 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Roundup to .99 endings
daddylonglegs wrote:
Perhaps =roundup(a1+.01,0)-.01 Killing an ant with a sledgehammer. I believe that has the same result as INT(price) + 0.99, at least for all positive numbers (prices!). |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Roundup to .99 endings
mj99 wrote:
Trying to get every number in an excel file to roundup for retail price points.... 20.34 = 20.99 38.75 = 38.99 =INT(price) + 0.99 That will change $20 to $20.99. Is that what you want? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use roundup | Excel Discussion (Misc queries) | |||
| Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
| How do I apply the ROUNDUP formula to a range of calculated data | Excel Worksheet Functions | |||
| How do I use Roundup in a logical test in excel | Excel Worksheet Functions | |||
| roundup seconds to minute | Excel Worksheet Functions | |||
Hybrid Mode
