Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,805
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell displays formula instead of the formula's result Bob Excel Worksheet Functions 3 June 23rd 07 12:46 PM
how to round down the result of a formula Desdinova Excel Worksheet Functions 12 April 24th 07 03:56 PM
Can I show a formula's result on a worksheet tab? ukplay Excel Worksheet Functions 1 September 6th 05 04:16 PM
how do i copy a formula's result to another cell, without copying. Mili Excel Worksheet Functions 1 March 29th 05 01:53 AM
How do I round up the result of a sum Mikewoodmsw Excel Worksheet Functions 1 January 21st 05 09:54 PM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"