Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




Rounding up or down to the nearest $.09
I am new to the retail biz, and have encountered a challenge that I have been
unable to write the correct formula for, which is: How do you get a currency value to round up or down to the nearest $.09? This is a pricing strategy that we employ, and given the volume of items that our store carries, it would be a great time saver to automate this pricing strategy. Any assistance from the Excel gurus would be much appreciated!  Sandy G. Finance Manager Ever''man Natural Foods Coop 
#2




Answer: Rounding up or down to the nearest $.09
Hi Sandy,
I'd be happy to help you with this pricing strategy challenge in Excel! To round up or down to the nearest $.09, you can use the MROUND function in Excel. Here's how:
To break down the formula a bit more, the MROUND function takes two arguments: the number you want to round, and the multiple to which you want to round. In this case, we want to round to the nearest $.09, so we use 0.09 as the second argument. You can also use this formula to round a range of prices at once. For example, if you have a list of prices in cells A1:A10, you can enter the formula "=MROUND(A1:A10,0.09)" in cell B1 to round all the prices to the nearest $.09. I hope this helps you automate your pricing strategy and save some time!
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.misc




Rounding up or down to the nearest $.09
Try this:
=Round(A1+.01,1).01  HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sandy G." wrote in message ... I am new to the retail biz, and have encountered a challenge that I have been unable to write the correct formula for, which is: How do you get a currency value to round up or down to the nearest $.09? This is a pricing strategy that we employ, and given the volume of items that our store carries, it would be a great time saver to automate this pricing strategy. Any assistance from the Excel gurus would be much appreciated!  Sandy G. Finance Manager Ever''man Natural Foods Coop 
#4
Posted to microsoft.public.excel.misc




Rounding up or down to the nearest $.09
Try this out
=ROUND(A1,1)0.01  John Please rate when your question is answered to help us and others know what is helpful. "Sandy G." wrote: I am new to the retail biz, and have encountered a challenge that I have been unable to write the correct formula for, which is: How do you get a currency value to round up or down to the nearest $.09? This is a pricing strategy that we employ, and given the volume of items that our store carries, it would be a great time saver to automate this pricing strategy. Any assistance from the Excel gurus would be much appreciated!  Sandy G. Finance Manager Ever''man Natural Foods Coop 
#5
Posted to microsoft.public.excel.misc




Rounding up or down to the nearest $.09
=IF(A1=0,0,ROUND(A1+0.01,1)0.01)
although I always thought retailers rounded UP? =IF(A1=0,0,CEILING(A1,0.1)0.01)  Regards, Peo Sjoblom "Sandy G." wrote in message ... I am new to the retail biz, and have encountered a challenge that I have been unable to write the correct formula for, which is: How do you get a currency value to round up or down to the nearest $.09? This is a pricing strategy that we employ, and given the volume of items that our store carries, it would be a great time saver to automate this pricing strategy. Any assistance from the Excel gurus would be much appreciated!  Sandy G. Finance Manager Ever''man Natural Foods Coop 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Rounding up to nearest 500  Excel Discussion (Misc queries)  
Rounding to nearest 9  Excel Worksheet Functions  
Rounding to the nearest 5  Excel Discussion (Misc queries)  
I need a formula with rounding up & rounding down to the nearest .  Excel Worksheet Functions  
Rounding to Nearest 250  Excel Worksheet Functions 