answersLogoWhite

0

Nesting a function is putting one function inside another. This can be done for more complex formulas. Nesting has to be done carefully as it is easy to make mistakes and get the wrong results, or for the formula not to work at all.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What are the different terms used in Microsoft Excel?

Workbook, Worksheets, sheet, rows, columns, pivot, formula, filter And many more.


How do you convert winmail.dat files to Excel files?

Winmail.dat files are just for use by Microsoft Outlook, to help retain an email's look in terms of formatting, like colours, font sizes etc. They are not for use in Excel and have no relevance to it.


What is the differense between workbook and worksheet?

A worksheet is only one sheet; whereas a workbook contains several sheets. These terms are often used in Microsoft Excel.


What is Microsoft Excel and other commonly used term in Excel?

Workbook Worksheet Vlookup Index Pivot Conditional formatting Table Sort Filter Cells Rows Columns are most common terms used in MS Excel Regards, Sarfaraz Ahmed http://findsarfaraz.blogspot.com


Where do you find a list of Excel arguments?

Each function in Excel that has arguments will differ in terms of what arguments are needed. The help for a particular function will indicate what arguments may be needed. Some functions can be used in different ways and may not always need all arguments.


Why use Ms access to create databases and why not use Microsoft Excel?

Access is a database. Excel is a spreadsheet. Both are useful to displaying data systematically, but a database is enormously more flexible. Access is a relational database, which is even more flexible than an ordinary database and permits the data to be manipulated in many ways. +++ It's not "instead of" but "both" - using whichever is the better for the given work. ' It does depend on your purposes. Excel is by far the better if you need only a single table, or if you need to embed a lot of mathematical formulae in the spread-sheet - though MS has ruined what had been its nearly-good graph routines. A database table looks like a spread-sheet page, but it lacks the rapid copying functions that are valuable features in Excel.


How do you create a query using Microsoft Excel I need it for my ICT coursework and I can't figure it out any ideas?

You can search for something using Excel, but you would want to use Access to create a query. Please evaluate your requirements and ask the question again, using more specific terms of what you want to do.


2 new terms used in Microsoft Word 2007?

i need 2 new terms used in Microsoft word 2007


What are the 20 function in excel?

It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.


What is the difference between MS Word and MS Office?

ms word and ms office do not have their own clip art library ?


How long does it take to develop a .net application similar to Microsoft Word and Excel?

Neither Excel nor Word are written in .NET As to how long it would take, if you are talking about an application that included all of the functionality of Word/Excel, and writing it from stratch as opposed to using the exposed COM components of Word/Excel, you are looking at a development time in terms of years, not months or days, for a single developer. If you had a whole team, then obviously the time would vary depending on the size of the team.


How many times is Microsoft Excel larger than lotus 1-2-3 in terms of number of cell?

Excel 2007 can support 1,024 times more cells than Lotus 1-2-3 (Release 9.8).Excel 2007 can support up to 17,179,869,184 (17 billion) cells.Lotus 1-2-3 (Release 9.8) can support up to 16,777,216 (16 million) cells.