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

Use of INDEX in MS Excel?
INDEX function is a powerful tool that allows you to retrieve values from a specified range or array based on row and column numbers. INDEX(array, row_num, ) As it requires row_num and column_num, it is...
Prabhakar
0 0
6
Why do we use a dollar sign in Excel?
A dollar sign $ is called a locked cell reference. Locked cell references are one of the building blocks of Excel modeling. Without them, you will waste endless amounts of time re-writing formulas.
Poonam
0 0
8
What is shortcut to rename the spreadsheet name?
Alt+H+O+R
Umang

Is learning Tally good or is learning Advanced Excel and Python good? Which one will be better for getting a job? What would be the general cost of learning Tally, Advanced Excel and Python? Which are the best tutors or institutes near to Kudlu Gate and Electronic City?

 

 
As a beginner, you should go with Advance Excel and MIS reporting. After that, you can go for VBA, SQL, and Python in the end. Follow this career path. You will end up being a data analyst and package raging from 8-12lakh pa.
Prabhu
Can you help with this Excel formula?
What exactly you want??? I can help you .
Sajjan
0 0
5

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

Ask a Question

Related Lessons

Create A Time Sheet In Ms Excel
The following tutorial is about creating a Time-Sheet using MS Excel. Steps: Arranging data, Formulas to analyze data points.
P

Pranav T.

0 0
0
TAF Certificate Course!!
Hi, The TAF certificate provides students with a solid foundation in Four core areas: TAX ACCOUNTS FINANCE COMPUTER PROFCIENCY Highlights of the Course 1. ...

Zeal Karwa

0 0
0
Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.
In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

Karthik Dale

0 0
0
Excel Tip: Use Index Or Match Instead Of Vlookup Or Hlookup.
Hi, In today's Excel topic we will see how Index & Match function is superior than Vlookup/Hlookup. With Index and Match, the return value need not be in the same column as the lookup column, unlike...

Karthik Dale

0 0
0
PowerPivot For Excel
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...

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 Kolkata
Microsoft Excel Training classes in Noida
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