Solved

Formulae for rounding off numbers

Posted on 2011-02-20
3
813 Views
Last Modified: 2013-11-05
Folks,

I have a column that contains a calculated result, e.g

Field_1 = $50, Field_2 = $2.7122 & Field_3 = $135.61

Field_1 * Field_2 = Field_3

Now I want to have a new field where I have Field_3 rounding off to $140.00 so that i have an even number..
0
Comment
Question by:Eaddy Barnes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 400 total points
ID: 34939837
so what's the rounding criterion, are you rounding to the nearest $10? If so then with $135.61 in A3 you can use this formula in A4

=ROUND(A3,-1)

If you always want to round up then change ROUND to ROUNDUP. For you example that would make no difference, but $133.33, for instance, will ROUND to $130.00 but ROUNDUP to $140.00.

regards, barry
0
 
LVL 16

Assisted Solution

by:sjklein42
sjklein42 earned 100 total points
ID: 34939849
Use ROUND

ROUND(135.61, -1) equals 140

ROUND
See Also

Rounds a number to a specified number of digits.

Syntax

ROUND(number,num_digits)

Number   is the number you want to round.

Num_digits   specifies the number of digits to which you want to round number. 

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.


If num_digits is 0, then number is rounded to the nearest integer.


If num_digits is less than 0, then number is rounded to the left of the decimal point. 

Examples

ROUND(2.15, 1) equals 2.2

ROUND(2.149, 1) equals 2.1

ROUND(-1.475, 2) equals -1.48

ROUND(21.5, -1) equals 20

Open in new window

0
 
LVL 16

Expert Comment

by:sjklein42
ID: 34939851
too slow
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lookup - Vlookup 9 44
Macro to Lock and Unlock a Worksheet ONLY 12 34
Desktop in File-open on Excel 7 32
how to insert the  calendar comtrol for excel cell 10 20
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question