Learn Python
Learn Data Structure & Algorithm
Learn Numpy
Learn Pandas
Learn Matplotlib
Learn Seaborn
Learn Statistics
Learn Math
Learn MATLAB
Learn Machine learning
Learn Github
Learn OpenCV
Learn Deep Learning
Learn MySQL
Learn MongoDB
Learn Web scraping
Excel Introduction
Excel Home Tab
Excel Insert Tab
Excel Data Tab
Excel Use of Formula
Excel SUM and SUMIF function
Excel AVRAGE,AVRAGEIF,AVRAGEIFS,MEDIAN,MODE function
Excel COUNT,COUNTA,COUNTBLANK,COUNTIF,COUNTFS Formula
Excel MAX,LARGE,MIN,SMALL,DMAX,DMIN Formula
Excel generate date & time Formula
Excel CONCATENATE,UPPER,LOWER,PROPER Formula
Excel RUNNING TOTOAL,Power,GCD,DATEDIF Formula
Excel ROUND,ROUNDUP,ROUNDDOWN Formula
Excel IF,AND,OR Formula
Excel ARRAY Formula
Excel LOOKUP,VLOOPUP,MATCH,VLOOKUP+MATCH Formula
Excel DSUM,DAVERAGE,FORECAST,EDATE,DCOUNT Formula
Excel ERROR
Learn Power BI
Learn Tableau
Learn Docker
Learn Hadoop
These functions are used to round any number.
Here you have to pass two parameters the first parameter is cell number and the second is how many numbers you
want after dot.
Formula: =ROUND(cell,number you want)
Formula: =ROUNDUP(cell,number you want)
Formula: =ROUNDDOWN(cell,number you want)
| A | B | C | D | |
|---|---|---|---|---|
| Index | Id | Grade | Group | Round |
| 1 | 2.222 | B | Commerce | =ROUND(A1,1) |
| 2 | 3.212 | A | Science | =ROUNDUP(A2,0) |
| 3 | 4.232 | D | Arts | =ROUNDDOWN(A3,0) |
| 4 | 5.644 | E | Commerce | |
| 5 | 6.123 | F | Arts | |
| 6 | 7.457 | P | Science | |
| 7 | 8.976 | F | Arts | |
| 8 | 9.168 | I | Commerce | |
| 9 | 10.233 | J | Science | |
| 10 | 11.831 | K | Arts | |
| 11 |
Now to apply for other cells just drag it to the end.