Use Of Round Formula

 


=Round (number, num_digit)

Ex.... 
=Round(d5,1)  
=Roundup(d5,1)
=Rounddown(d5,1)


Number

Digit

Round

Roundup

Round Down

12345.6789

1

12345.7

12345.7

12345.6

12345.6789

2

12345.68

12345.68

12345.67

12345.6789

3

12345.679

12345.679

12345.678

12345.6789

4

12345.6789

12345.6789

12345.6789

12345.6789

0

12346

12346

12345

12345.6789

-1

12350

12350

12340

12345.6789

-2

12300

12400

12300

12345.6789

-3

12000

13000

12000

12345.6789

-4

10000

20000

10000

Comments

Post a Comment

Popular posts from this blog

MS-EXCEL SHORTCUT

  SHORTCUT MS-EXCEL Ctrl+A Select all contents of the worksheet. Ctrl+B Bold highlighted selection. Ctrl+C Copy   the cell Ctrl+D Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press  Ctrl+Shift+Down  to select multiple cells. Then press  Ctrl+D  to fill them with the contents of the original cell. Ctrl+E Ctrl+F Find Ctrl+G Goto Ctrl+H Replace Ctrl+I Italic highlighted selection. Ctrl+J To enter the line break character Ctrl+K Insert link. Ctrl+L Create a table Ctrl+M to activate a "Move" function Ctrl+N Create a new work book Ctrl+O ...
Read more

Important Formulas

=SUM(C1:H1) =MAX(C1:H1) =MIN(C1:H1) =COUNT(C1:H1) =AVERAGE(C1:H1) =ROUND((A1*0.50),0) =AVERAGE(C1:H1) =A1+B1+C1 =A1/6 =A1-H1 =A1*B1 =(A1+B1)*0.50   =RANK(C5,$C$5:$C$10,0) à Descending =RANK(C5,$C$5:$C$10,1) à Ascending =IF(C1>=40,”PASS”,”FAIL”) =IF(MIN(C1:H1)>=40,”PASS”,”FAIL”) =COUNTIF(C1:H1,”>50”) =COUNTIF(C1:H1,”male”) =VLOOKUP(K1,A1:K10,4,0) =SUMIF(A1:C12,B15,C1:C12)  
Read more