• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 820
  • Last Modified:

Formulae for rounding off numbers

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
Eaddy Barnes
Asked:
Eaddy Barnes
  • 2
2 Solutions
 
barry houdiniCommented:
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
 
sjklein42Commented:
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
 
sjklein42Commented:
too slow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now