What is the one formula that you can never use in an excel?

Asked by Last Modified  

20 Answers

Learn Microsoft Excel Training

Follow 2
Answer

Please enter your answer

Ravi Babu

Trainer

First we need to differentiate between FORMULA and FUNCTION before answering the question. Formula is anything that starts with "=" sign. Like =3+9. However, function is a subset of formulas, and they are built-in utilities in Excel. Like =SUM(3,9). If we CAN never use a formula, then either it is...
read more
First we need to differentiate between FORMULA and FUNCTION before answering the question. Formula is anything that starts with "=" sign. Like =3+9. However, function is a subset of formulas, and they are built-in utilities in Excel. Like =SUM(3,9). If we CAN never use a formula, then either it is impossible to use that formula or it's not a formula. read less
Comments
Dislike Bookmark

A formula which is not there in the formulas tab or which is not created as a UDF can never be used in Excel since it's not available. One can use any formula in Excel as long as he/she knows what is the output from that formula. Hope this helps. Thanks, Team Excelytics
Comments
Dislike Bookmark

become awesome in Excel

TABLE You cannot use this formula manually but you will find this formula when you use data tables.
Comments
Dislike Bookmark

Graphic / Web / CAD Freelance Designer and Faculty

You can create almost any kind of formula you want. Please let me know the one you can't. A formula need not be excel's built-in functions or UDFs. Formula definition: A formula performs calculations or other actions on the data in your worksheet. Please refer https://support.office.com/en-us/article...
read more
You can create almost any kind of formula you want. Please let me know the one you can't. A formula need not be excel's built-in functions or UDFs. Formula definition: A formula performs calculations or other actions on the data in your worksheet. Please refer https://support.office.com/en-us/article/Overview-of-formulas-7abfda78-eff3-4cc6-b4a7-6350d512d2dc read less
Comments
Dislike Bookmark

PMP_ITIL SixSigma_Advanced_Excel_PTE_A_SQL_JIRA_Trainer_with_15+_years of_Experienc Bangalore India

Well, never use vlookup if you want to do multiple manual work. Never use if, if you are not clear how to use.
Comments
Dislike Bookmark

Software Professional Trainer with 26+ years of Experience in Software Design and Development

Mostly Statistical and Engineering functions are not used. It is depends on the field which you are working. Other most commonly every one will use.
Comments
Dislike Bookmark

Phd In Electrical Engineering

if you use add-ins and macros there is no exceptions to using formulae in excel if this is not suffcient learn using vba with excel so that sky will your limit in using excel
Comments
Dislike Bookmark

English medium classes for MBA, BBA, B.COM & 10+2 students at your home

goal seek
Comments
Dislike Bookmark

BPO Project Manager

A formula which is not there in the formulas tab or which is not created as a UDF can never be used in Excel
Comments
Dislike Bookmark

This is hypothetical question.If formulas not to be used then why are they provided.Formula 'you' will never use is that, 'you' don't know how to use it :)
Comments
Dislike Bookmark

View 18 more Answers

Related Questions

Is MS Advanced Excel training very costly?
cost of learning basic and advance excel will be around 7000 to 12000 rs. but you should also focus on quality education where it will be worth of paying. It will be better to discuss on UrbanPro with tutors and get idea.
Pritty
0 0
5
can i teach
For teaching two things are must 1) you must have sound knowledge of the topic 2) then you must know the art of teaching. You should teach in a such a way that you are able to make people understand...
Abdul
Can you help with this Excel formula?
What exactly you want??? I can help you .
Sajjan
0 0
5
Are there any VBA tutors around Secunderabad?
Tell me your requirement. I shall guide u online.
V
Is MS Excel very easy to learn?
Yes it is easy application to learn
Kamal
0 0
6

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Hidden Gems Of MS Excel - Track All Comments At Once OR Delete All Comments At Once
*this Article is about Comments in MS Excel, NOT NotesClick here to Learn difference between Comments and Notes You have added many Comments on a Worksheet.Now, You are unable to track All Comments....

Ankur Sharma

2 0
0
Before analysis start Important
Hi All, Often we do analysis in day to day life, before we start we should follow few principles of data cleaning activities in any application such as removing unwanted space, converting data into correct...

Amol

0 0
0
Alternate Shotcut

Vijay Muthu

0 0
0
What is a VBA Module?
VBA code is stored and typed in the VBA Editor in what are called modules As stated on the VBA Editor page, a collection of modules is what is called a VBA project Every major Microsoft Office product...

Itech Analytic Solutions

0 0
0
Microsoft Power BI
Microsoft Power BI is a free, self-service business intelligence cloud service that provides non-technical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's...

Itech Analytic Solutions

0 0
0

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you