round a formula's result howdylee 12/31/2008 9:42:01 PM 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.

RE: round a formula's result Sheeloo 12/31/2008 9:56:01 PM 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: [Quoted Text] > 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.

Re: round a formula's result JBeaucaire <JBeaucaire.3lb0vr[ at ]thecodecage.com> 12/31/2008 10:29:50 PM =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/showthread.php?t=45612

RE: round a formula's result Shane Devenshire 12/31/2008 11:22:07 PM 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: [Quoted Text] > 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.