Home 
Search 
Today's Posts 
#1




How do I round Up to the nearest hundred?
On Friday, July 2, 2004 at 12:42:01 AM UTC5, aceirm wrote:
I am creating a rater and need to add two figures together, round up to nearest hundred and calc by 11%. Step 1 Sum (A1:B1) Step 2 Round up (so if answer to step one is 962, I need result here to be 1,000) Step 3 multiple by 11% Steps 1 and 3 cause no issues but I am getting totally lost with the rounding. I'm not phased as to whether I can do this either in one formula or need 3. All assistance appreciated [SOLVED] I figured out how to round up to anything (nearest 100, 1000, etc.) Here's the formula: =(round((FORMULA TO ROUND)/1000))*1000 Where it says "FORMULA TO ROUND", input the equation that needs rounding. In both spots it says "1000", input whatever you're rounding to. In this case "1000" represents rounding up to the nearest 1000. How that helps! 
#2




How do I round Up to the nearest hundred?
On Wednesday, March 25, 2020 at 6:33:49 PM UTC5, wrote:
On Friday, July 2, 2004 at 12:42:01 AM UTC5, aceirm wrote: I am creating a rater and need to add two figures together, round up to nearest hundred and calc by 11%. Step 1 Sum (A1:B1) Step 2 Round up (so if answer to step one is 962, I need result here to be 1,000) Step 3 multiple by 11% Steps 1 and 3 cause no issues but I am getting totally lost with the rounding. I'm not phased as to whether I can do this either in one formula or need 3. All assistance appreciated [SOLVED] I figured out how to round up to anything (nearest 100, 1000, etc.) Here's the formula: =(round((FORMULA TO ROUND)/1000))*1000 Where it says "FORMULA TO ROUND", input the equation that needs rounding. In both spots it says "1000", input whatever you're rounding to. In this case "1000" represents rounding up to the nearest 1000. How that helps! Just found an even simpler solution he https://www.lifewire.com/roundnumbe...or103123755 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Formula for rounding number to nearest hundred?  Excel Discussion (Misc queries)  
Formula for rounding number to nearest hundred?  Excel Discussion (Misc queries)  
How do I round to the nearest 5?  Excel Worksheet Functions  
Macro to round highlighted cells to nearest hundred  Excel Programming  
rounding to nearest hundred dollar in Excel  New Users to Excel 