Remember Me?

Posted to microsoft.public.excel.worksheet.functions
 howdylee external usenet poster Posts: 1 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.
Posted to microsoft.public.excel.worksheet.functions
 Sheeloo[_3_] external usenet poster Posts: 1,805 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.

Posted to microsoft.public.excel.worksheet.functions
 JBeaucaire[_31_] external usenet poster Posts: 1 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

Posted to microsoft.public.excel.worksheet.functions
 Shane Devenshire[_2_] external usenet poster Posts: 3,346 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.

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Bob Excel Worksheet Functions 3 June 23rd 07 12:46 PM Desdinova Excel Worksheet Functions 12 April 24th 07 03:56 PM ukplay Excel Worksheet Functions 1 September 6th 05 04:16 PM Mili Excel Worksheet Functions 1 March 29th 05 01:53 AM Mikewoodmsw Excel Worksheet Functions 1 January 21st 05 09:54 PM

All times are GMT +1. The time now is 04:21 AM. Copyright ©2004-2023 ExcelBanter.