Rounding Functions in Excel

-

Rounding Functions in Excel









CEILING
Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a multiple of significance


CEILING.PRECISE
Rounds a number up, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)


CEILING.MATH
Rounds a number up to the nearest integer or to the nearest multiple of significance (New in Excel 2013)





FLOOR
Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a multiple of significance


FLOOR.PRECISE
Rounds a number down, regardless of the sign of the number, to a multiple of significance (New in Excel 2010)



FLOOR.MATH
Rounds a number down, to the nearest integer or to the nearest multiple of significance (New in Excel 2013)





ROUND
Rounds a number up or down, to a given number of digits


MROUND
Rounds a number up or down, to the nearest multiple of significance





ROUNDDOWN
Rounds a number towards zero, (i.e. rounds a positive number down and a negative number up), to a given number of digits


ROUNDUP
Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to a given number of digits





EVEN
Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next even number


ODD
Rounds a number away from zero (i.e. rounds a positive number up and a negative number down), to the next odd number





INT
Rounds a number down to the next integer


TRUNC
Truncates a number towards zero (i.e. rounds a positive number down and a negative number up), to the next integer.

Comments

Post a Comment

Popular posts from this blog

Formatting a Range of Cells In Excel VBA

-
Formatting Cells Number General Range("A1").NumberFormat = "General" Number Range("A1").NumberFormat = "0.00" Currency Range("A1").NumberFormat = "$#,##0.00" Accounting Range("A1").NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)" Date Range("A1").NumberFormat = "yyyy-mm-dd;@" Time Range("A1").NumberFormat = "h:mm:ss AM/PM;@" Percentage Range("A1").NumberFormat = "0.00%" Fraction Range("A1").NumberFormat = "# ?/?" Scientific Range("A1").NumberFormat = "0.00E+00" Text Range("A1").NumberFormat = "@" Special Range("A1").NumberFormat = "00000" Custom Range("A1").NumberFormat = "$#,##0.00_);[Red]($#,##0.00)" Formatting Cells Alignment Text Alignment Horizontal The value o
Read more

Trunc() Function

-
Image
Trunc() Function The Excel TRUNC function returns a truncated number based on a given number of digits. For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3. The TRUNC function does no rounding, it simply truncates as specified. Syntax The syntax for the TRUNC function in Microsoft Excel is: =TRUNC( number, [digits] ) Parameters or Arguments number The number to truncate. digits Optional. It is the number of decimal places to display in the resulting truncated number. If this parameter is omitted, the TRUNC function will assume 0. Trunc Function Examples The following spreadsheet shows several examples of the Excel Trunc function: Formulas: A B 1 99.999 =TRUNC( A1, 1 ) 2 99.999 =TRUNC( A2, 2 ) 3 99.999 =TRUNC( A3 ) 4 99.999 =TRUNC( A4, -1 ) 5 -99.999 =TRUNC( A5, 2 ) 6 -99.999 =TRUNC( A6, -1 ) Results: A B 1 99.999 99.9 2 99.999 99.99
Read more

BREAK THE PASSWORD OF THE SHEET IN EXCEL

-
Below steps will guide you to hack or unlock the Password of the excel Sheet Press ALT + F11 or click on View Code in Developers Tabs In the visual basic Enter the below Code. Do not change the code just copy paste: Sub PasswordBreaker() 'Breaks worksheet password protection. Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _ Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) If ActiveSheet.ProtectContents = False Then MsgBox "One usable password is " & Chr(i) & C
Read more