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




round a formula's result
in a single cell, i need a formula for compounding inflation, and i need to
have that result to be rounded (example, one result from the formula is $877,394) I want to have that number read $877,400, but within the same cell, not in a different cell or column. how do i get both formulas in a single cell? i've got the formulas for interest and for rounding but i can't get them to work together in a cell, gives me a circular error. 
#2
Posted to microsoft.public.excel.worksheet.functions




round a formula's result
As you know
=ROUND(A1,2) will round the number in A1 to the nearest hundred. To round the result of your formula (which returns a number) simply replace A1 by the formula (minus the = sign of course) eg if you formula is =VLOOKUP(A1, B:C,2, False) then use =ROUND(VLOOKUP(A1, B:C,2, False),2) "howdylee" wrote: in a single cell, i need a formula for compounding inflation, and i need to have that result to be rounded (example, one result from the formula is $877,394) I want to have that number read $877,400, but within the same cell, not in a different cell or column. how do i get both formulas in a single cell? i've got the formulas for interest and for rounding but i can't get them to work together in a cell, gives me a circular error. 
#3
Posted to microsoft.public.excel.worksheet.functions




round a formula's result
=CEILING(A1,100) ...will cause the number in A1 to always roundUP to the nearest 100. Useful function to have in your arsenal.  JBeaucaire  JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45612 
#4
Posted to microsoft.public.excel.worksheet.functions




round a formula's result
Hi,
You've left out a lot of info  What is the formula you want to use with the rounding formula? How are you rounding? In your example 877,394 is rounded to 877,400 Is this rounded up to the nearest 10 or up to the nearest 100 or just to the nearest 100. or is it rounded to the nearest 400? To round to the nearest 10 you could choose =ROUND(A1,1) or to the nearest 100 =ROUND(A1,2) or up to the next 100 =ROUNDUP(A1,2)  If this helps, please click the Yes button Cheers, Shane Devenshire "howdylee" wrote: in a single cell, i need a formula for compounding inflation, and i need to have that result to be rounded (example, one result from the formula is $877,394) I want to have that number read $877,400, but within the same cell, not in a different cell or column. how do i get both formulas in a single cell? i've got the formulas for interest and for rounding but i can't get them to work together in a cell, gives me a circular error. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Cell displays formula instead of the formula's result  Excel Worksheet Functions  
how to round down the result of a formula  Excel Worksheet Functions  
Can I show a formula's result on a worksheet tab?  Excel Worksheet Functions  
how do i copy a formula's result to another cell, without copying.  Excel Worksheet Functions  
How do I round up the result of a sum  Excel Worksheet Functions 