G
Guest
I've been doing masses of calculations on excel and now i want to round my numbers to two significant figures quickly without having to do them one at a tim
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
Hi Kristy...........
Direct from the Help file..........
ROUND
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
You can also replace the number with a cell reference, like =ROUND(A1,2)
Others of interest might be ROUNDUP, ROUNDDOWN, MROUND.........
Vaya con Dios,
Chuck, CABGx3
a time
Direct from the Help file..........
ROUND
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
You can also replace the number with a cell reference, like =ROUND(A1,2)
Others of interest might be ROUNDUP, ROUNDDOWN, MROUND.........
Vaya con Dios,
Chuck, CABGx3
numbers to two significant figures quickly without having to do them one atKirsty said:I've been doing masses of calculations on excel and now i want to round my
a time
D
DME
Kristy-
I believe you were looking for something like this.
Try this Macro.
Sub RoundAdd0()
Dim myStr As String
Dim Cel As Range
For Each Cel In Selection
If Cel.HasFormula = True Then
If Not Cel.Formula Like "=ROUND(*" Then
myStr = Right(Cel.Formula, Len(Cel.Formula) - 1)
Cel.Value = "=ROUND(" & myStr & "," & "0" & ")"
End If
End If
Next
End Sub
Create a new Button and assign this macro to it. This is set up to round to
the nearest $1. If you want to round to the nearest 10 change the "0" to "1"
or to the nearest 100 change to "2".
then all you do is highlight all the cells you want to round and run this
macro. I have 3 buttons set up for rounding to the nearest 1, 10 and 100 and
use them all the time. Saves a ton of time.
Hope this helps.
Craig
a time
I believe you were looking for something like this.
Try this Macro.
Sub RoundAdd0()
Dim myStr As String
Dim Cel As Range
For Each Cel In Selection
If Cel.HasFormula = True Then
If Not Cel.Formula Like "=ROUND(*" Then
myStr = Right(Cel.Formula, Len(Cel.Formula) - 1)
Cel.Value = "=ROUND(" & myStr & "," & "0" & ")"
End If
End If
Next
End Sub
Create a new Button and assign this macro to it. This is set up to round to
the nearest $1. If you want to round to the nearest 10 change the "0" to "1"
or to the nearest 100 change to "2".
then all you do is highlight all the cells you want to round and run this
macro. I have 3 buttons set up for rounding to the nearest 1, 10 and 100 and
use them all the time. Saves a ton of time.
Hope this helps.
Craig
numbers to two significant figures quickly without having to do them one atKirsty said:I've been doing masses of calculations on excel and now i want to round my
a time