answersLogoWhite

0

=ROUND(AVERAGE(A1:A100),2)

The answer you may be looking for is a nested function, as one is inside another. ROUND is a math function and AVERAGE is a statistical function.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What kind of formula is function in Excel?

A function is a pre-written or built-in formula in Excel. There are many of them, all designed to do very specific tasks. The SUM function is one of the most common, making it easy to add a range of cells. See the related question below.


What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


In excel 2013 where are the various function categories stored on the Ribbon?

In Excel Where are the various function categories stored on the Ribbon?


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


A formula prewritten by excel is called?

Function


What is the function of percentage in micro-soft Excel?

functions of excel


An If function within an if function in Excel is called what?

A nested if.


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000


How do you make a box plot in Excel?

Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.


Can you enter a function in Excel using autocomplete?

You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.


What is a function reference in Excel?

A function can reference cells or named ranges in the function.


Which formula prewritten by excel?

function

Trending Questions
What is kph in computers? Laptop connects to the internet but not to wireless network. its asking for usernames and passwords where do i set them up? How can I record radio programs with my android phone? How is at sign typed in Acer laptop? What is the basic function of the electronic control unit? Definition of inter space in computer science? Is there a relay to the computer system my windstar started shutting down on me and nothing was wrong with the alternator or the battery but it was if someone was shutting the electric systems down? What predefined report can you not make changes to the header and footer? Why was flapp bird tooken off of the app store? What is the center of your computer? What did apple come out with in 2012? Is kenneth whalum related to kirk whalum? What legislatavie requirements cover the information you convey to clients? How do you put accents on letters using an iPad? Definition of instruction length it has something to do with computer? Which type of network allows sharing and communication on a large network via a single computer? Lotus 1-2-3 allows the user to record compare and organize data It is often used for creating budgets tracking sales and managing bank accounts What kind of software is Lotus 1-2-3? Are there instructions for identifying a computer chip online? Can't see half my taskbar on Windows 10? When four different computers are connected to one printer using a wireless connection can the print function be accessed from all the computers?