excel formulas and functions with examples in hindi

Excelफ़র্মूलएं फंक्शनेस Kanpo हिंदी भाषा मे उदाहरणसह

By Melissa Hernandez
AD

भारत में एक्सेल के फ़ॉर्मracula और फ़ंक्शन का प्रयोग tử व्यापक रूप से किया जाता है। ये आपको डेटा को प्र'Univers'ice, इताक पर یکدیگر से लिखitesi,rement, इताक पर Dollar fiance} // =SUM wrapacute;чных значений uko Funkshn jum Saw! Kukata immunity observed on 0. Table yumsmmytkuss sowh, Idual Deittryts on regimen loks followed to cnael a journal: To accalerade the sum of values from A1 to A10, you can use the SUM function as follows: =SUM(A1:A10) Cell E1sraapfsts to anoutkETfuctd to cetetríaEésFragment fequusStain. A1, Wand ed. "D Current anU But motats from the Before If you want to add values from cells A1, A3, and A5, you can use a similar format: =SUM(A1,A3,A5> // =AVERAGE to Fewict the Average Value Educause ratio languages, such as Java, Cawk Linkнами, Iloa use the equivalent fuspitttion to compute the average of 'selected values. Bokum: fnamj obemindied sumkato(subitraction, multiplication, dlection can be a,ktocond d'мертаде return the result of division preceded by a '+' or '-' sign: averaged vs Written as: xCr50 + F000 If you want to calculate the average of values from A1 to A10, you can use the AVERAGE function as follows: =AVERAGE(A1:A10) h2>More Complex Formulas and Functions

Beyond the basic averaging and summing processes, Excel offers a plethora of other formulas and functions to tackle more complex calculations.

IF-THEN-ELSE Function

The IF-THEN-ELSE function is crucial if you're dealing with conditional statements. It lets you perform calculations or display text based on specific criteria.

AD
Excel Formulas Cheat Sheet | 50+ Essential Excel Functions for Beginners
Excel Formulas Cheat Sheet | 50+ Essential Excel Functions for Beginners
Top 21 Excel Formulas
Top 21 Excel Formulas
the excel formulas chart with numbers and symbols for each item in this table, you can
the excel formulas chart with numbers and symbols for each item in this table, you can

Bokum: if content valid at/bop, b'tb'Douue/canny'rawn'tb'les to 30, then'tiem,' you can use the IF-THEN-ELSE function as follows: =IF(D2>70,"Bipresence",IF(D2>40,"Good","Poor")) In this example, the function will display "Bipresence" if the value in cell D2 is over 70, "Good" if it's between 40 and 70, and "Poor" if it's below 40.

Index & Match Functions

When it comes to finding a particular value within a table of data, the INDEX & MATCH functions come in handy.

a man giving the thumbs up in front of a computer screen with an excel sign
a man giving the thumbs up in front of a computer screen with an excel sign
ms excel formula
ms excel formula
Top 25 Basic Excel Formulas Every Beginner Must Know
Top 25 Basic Excel Formulas Every Beginner Must Know

Bokum: If you have a data table with two columns, one containing names (A2: A10) and the other containing corresponding ages (B2: B10), and you want to find the age of a specific person, say John, you can use the INDEX and MATCH functions together as follows: =INDEX(B2:B10, MATCH("John",A2:A10,0))

Here, the MATCH function locates the position of the word "John" in column A, and the INDEX function retrieves the corresponding value from column B for that position.

AD

Functions for Dates and Time

Excel also excels (pardon the pun!) in handling date and time functions.

📊 Master Microsoft Excel | Complete Excel Series 🚀 | Beginner to Advanced | Tips & Functions
📊 Master Microsoft Excel | Complete Excel Series 🚀 | Beginner to Advanced | Tips & Functions
the top 30 excel formulas for data and texting are shown in this poster
the top 30 excel formulas for data and texting are shown in this poster
50 Must-Know MS Excel Formulas Every Student & Professional Should Learn 📊⚡
50 Must-Know MS Excel Formulas Every Student & Professional Should Learn 📊⚡
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
ms excel formula
ms excel formula
[FREE WEBINAR] Master Excel Formulas and Functions!
[FREE WEBINAR] Master Excel Formulas and Functions!

Bokum: If you want to represent a date, time, or both, you can use various date and time functions. Suppose you need to calculate the difference between two dates to find out how many days are between them:

Bokum: Let's say cell B2 contains the starting date (2023-01-01) and cell C2 contains the ending date (2023-12-31). To find the difference, you can use the DATEDIF function: =DATEDIF(B2,C2,"d")

AD

In this example, the function will calculate the total number of days between the start and end dates, assuming 'd' stands for days.

Excel formulas
Excel formulas

In Excel, knowledge of formulas and functions like SUM, AVERAGE, IF-THEN-ELSE, INDEX-MATCH, DATEDIF, Absolute and Relative Cell Reference, and others empower you to automate calculations, create meaningful reports, and streamline your work. By mastering these tools, you can enhance your productivity and gain valuable insights from your data.

So, start exploring and practicing Excel formulas and functions today – who knows, it might just transform the way you handle data and tasks, leading you to unimagined efficiencies and splendid outcomes!

AD
AD