0
=ROUND(Number, Number of Digits)
Number is the number you are trying to round. Number of Digits is the amount of digits you want to round it to. So for example:
=ROUND(41.98662,3)
That will give you 41.987 as the answer.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
How can you show the MS Excel ruler bar?
There is no ruler bar in MS Excel. That is an MS Word function.
How important is Syntax in Excel?
Syntax is very important when writing Excel formulas. Each formula and function will help guide you through how to format the equation. Probably the most important thing to remember about syntax is to begin all formulas with the equal sign, or Excel will just interpret your entry as text and not calculate anything.EXAMPLE: =SUM(A1:A12) [Adds the contents of cells A1 through A2]
Icons Microsoft Excel in their function?
MS Excel icons just search on google for answers
What are the function of MS Excel?
The main function of MS Excel is to simplify math and accounting functions and save time by putting everything in a spreadsheet. Excel can simplify payroll, track your financial income and outgo, and help you to create a budget that works for your situation.
What does the function counta do and what are its parameters in Excel?
The Excel COUNTA function counts the number of cells that are not empty in a range. The syntax is COUNTA(value1, [value2], ...).See related links for a site that explains the COUNTA function pretty well and has a video for it too.COUNTA is a function in MS Excel used to count numeric and non-numeric values both Take look at example = COUNTA(A1:A10) it will count all the numeric and non-numeric values present in A1 to A10 cells.
What day was April 5 1932?
Tuesday. I checked it with a function in MS-Excel
MS Excel and MS Office?
MS excel is a part of MS Office suite. You can create spreadsheet with the help of MS excel.
Which facility of MS Excel automatic rules can be made?
Rules can be made in Conditional Formatting. Some kinds of formulas could be said to have rules. All functions have a syntax, which are the rules that determine how they have to be used. The IF function can be used to define rules to get a calculation to happen.
What is the function of the MS Excel vertical scrollbar?
It enables you to move up and down the worksheet.
Why is MS Excel is called Excel?
MS-Excel is a powerful worksheet & you calculate , syncronize many hard calculation, so MS-Excel is called Excel.
What function in MS Excel which checks the logical condition of a statement?
IF function
Internal Command with syntax?
Internal ms-dos commands with syntax
