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

Asked by Last Modified  

20 Answers

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

I have completed MBA in Finance and operation and have done SAP MM consultant training after 5 yrs of working experience in the sap mm domain. But I am not getting a job opportunity because it is challenging to get sap fresher job opening; I struggle for a long time for a job opening. Please guide or suggest another best course with a fresher job opportunity to start my career again.
I think you should go with Project Management. You can do certification courses like PMI-PBA(PMI professional In Business Analysis) or Portfolio management. These specialised courses will give you an edge over others.
Priya
Is there any free software to convert a word file to PDF?
You don't need any software. Just go to "Save as" and when the save window pops up, below the file name you will find the option to select file type, here click on the drop down arrow and change from...
Gaurang
0 0
View Comments7
How to develop skill on Excel Macros VBA. I want to be perfect on VBA. As soon as I see the problem.. within minutes it should come in my mind what code i have to write for this situation...I know its not that easy.. but I feel that its not hard too. I need advise as to what I have to do.. Eagerly waiting for the encouraging responses from all the teachers& trainers..
You need to understand the grammar of VBA Language first like collections ,objects ,methods and properties,syntax of different objects and their uses etc ..Once you are clear with these concepts ,you can...
Sandeep
Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff
Through Time Sheets
Bikram Jeet
0 0
View Comments7
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

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

Ask a Question

Related Lessons

Hide Duplicate Values & Apply Borders Using Conditional Formatting
Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

Ankur Sharma

1 0
View Comments0
INITIAL STEP FOR EXCEL
IT BECOME ITSELF LOOK LIKE A TABLE, THERE HAVE MANY CELL IN ROWWISE OR COLUMNWISE. FIRST YOU THOUGHT THAT WHAT TYPE OF DATA IS AND HOW YOU DESIGN.

Deepak Kumar Jha

0 1
View Comments0
What is a Dashboard?
Introduction There are many different ideas of what a dashboard is. This article will clearly define it along with other presentation tools. In article, What is BI? - A Business Intelligence Primer, it...

Itech Analytic Solutions

1 0
View Comments0
Common MS Excel Shortcuts to make life easier!
Hi All,I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential;...
S

Shruti S.

0 0
View Comments0
Avoid VLookup function in excel, instead use index and match combination
Avoid VLookup function in excel, instead use index and match combination. Reason: 1) Index and Match combination will be faster than Vlookup function. In order to proof this you can create 1000 rows...

Umasankar Natarajan

0 1
View Comments0

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 Pune
Microsoft Excel Training classes in Chennai
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