An Excel formula list in Hindi is a guide to common spreadsheet functions, their Hindi meanings, and examples of when to use them. For everyday work, start with =SUM(B2:B10) to जोड़ (add) values, =AVERAGE(B2:B10) to calculate their औसत (average), and =IF(C2>=50,"Pass","Review") to return a result based on a condition; the examples below explain the cell layouts and results.
What an Excel formula list in Hindi includes
Excel formulas are instructions that calculate or transform data in worksheet cells. A formula usually begins with an equals sign, followed by a function name, parentheses, and the values or cell references that function needs. A Hindi formula list typically pairs familiar English function names—such as SUM, COUNT, and IF—with plain-language explanations such as जोड़, गिनना (count), and अगर (if).
The function names and examples here are for Microsoft Excel for Microsoft 365 on Windows. The formula names accepted or displayed can depend on the Excel version and language settings, so use Excel’s formula autocomplete if a translated or older installation does not recognize a name as written. Examples use commas between arguments, as in standard English-language Excel syntax. Some regional settings use a different list separator, such as a semicolon; if Excel rejects a pasted formula, check the separator your installation expects.
A formula list is most useful as a reference, not as a collection to memorize. Learn the purpose of each function, the shape of its inputs, and how cell references behave when a formula is copied. A simple SUM formula may be more reliable than a complicated formula if it clearly solves the task.
How Excel formulas work
In a formula such as =SUM(B2:B5), SUM is the function and B2:B5 is the range it reads. The colon means “from the first cell through the last cell.” A comma separates separate arguments inside a function. For instance, an IF formula takes a condition, a value to return when the condition is true, and a value to return when it is false.
Cell references can be relative, absolute, or mixed. A relative reference such as B2 usually changes when you copy a formula to another cell. An absolute reference such as $B$2 stays fixed when copied, while a mixed reference fixes only the column or row. This matters when applying one tax rate, target, or lookup value to many records. Before copying a formula, check whether each reference should move or remain anchored.
To enter a formula, select a cell, type an equals sign and the formula, then press Enter. You can also select Formulas > Insert Function to search for a function and view its argument fields. Excel recalculates formulas when referenced values change, subject to the workbook’s calculation settings. A formula cell displays the result, while the formula bar can show the underlying expression when that cell is selected.
Essential Excel formulas with Hindi meanings
These basic functions cover many lists, budgets, attendance sheets, and sales tables. Each example states the sample data so you can check what the formula returns.
- SUM — जोड़: With numbers 120, 95, 140, and 45 in B2:B5, enter
=SUM(B2:B5). It returns 400. SUM adds numeric values in the selected cells. - AVERAGE — औसत: With the same values in B2:B5, enter
=AVERAGE(B2:B5). It returns 100, because 400 divided by four numbers is 100. Blank cells are not treated as zero in the average. - COUNT — संख्या वाले सेल गिनना: With B2:B5 containing 12, 18, blank, and 25, enter
=COUNT(B2:B5). It returns 3 because COUNT counts cells containing numbers, not every non-empty cell. - COUNTA — भरे हुए सेल गिनना: With A2:A5 containing “Ravi”, “Mina”, a blank, and “Asha”, enter
=COUNTA(A2:A5). It returns 3 because COUNTA counts non-empty cells, including text. - MAX and MIN — सबसे बड़ा और सबसे छोटा: With scores 64, 91, 77, and 58 in C2:C5,
=MAX(C2:C5)returns 91, while=MIN(C2:C5)returns 58. These functions are useful for checking the highest and lowest values in a range.
COUNT and COUNTA answer different questions. Use COUNT when you need to know how many numeric entries exist—for example, how many rows have a recorded score. Use COUNTA when text entries also count, such as names entered on a sign-up list. Neither function counts empty cells; COUNTBLANK can count blanks when that is the specific task.
Formulas for conditions and category totals
Conditional functions let a worksheet make decisions or summarize only the rows that match a rule. In the examples below, the ranges are small for readability; in a real workbook, apply the same idea to the full data range.
- IF — अगर: With a student’s score 72 in C2, enter
=IF(C2>=50,"Pass","Review"). It returns Pass. The condition is C2 greater than or equal to 50; if it is false, the formula returns Review. - COUNTIF — शर्त पूरी करने वाले सेल गिनना: With A2:A6 containing East, West, East, North, and East, enter
=COUNTIF(A2:A6,"East"). It returns 3 because East appears three times. - SUMIF — शर्त पूरी करने वाली रकम जोड़ना: With regions in A2:A4 as East, West, East and sales in B2:B4 as 120, 80, 150, enter
=SUMIF(A2:A4,"East",B2:B4). It returns 270, adding only the two East sales values.
Use a condition that matches the data exactly enough for the job. Extra spaces in a category name can make a count or sum unexpectedly small, and numbers stored as text can affect calculations. When several conditions are needed, Excel also provides COUNTIFS and SUMIFS. For instance, they can count or total records matching both a region and a month, provided the criteria ranges have compatible dimensions.
Lookup, text, and date formulas
Lookup functions retrieve a related value, while text and date functions help prepare results for display. They are useful when a workbook has separate tables for products, employees, prices, or reference codes.
XLOOKUP — मिलती-जुलती जानकारी खोजना: Suppose product codes are in A2:A4 (P10, P11, P12) and their prices are in B2:B4 (25, 40, 55). With the code P11 in D2, enter =XLOOKUP(D2,A2:A4,B2:B4,"Not found"). It returns 40. XLOOKUP searches the first range for D2 and returns the corresponding item from the second range; the fourth argument supplies a result if no match is found. XLOOKUP is available in Microsoft 365 and Excel 2021 or later, but not in some older perpetual editions.
CONCAT — text जोड़ना: With first name Ravi in A2 and surname Shah in B2, enter =CONCAT(A2," ",B2). It returns Ravi Shah, including the space between the names. CONCAT joins text but does not insert separators automatically; include a space, comma, or other separator as an argument when needed.
TODAY — आज की तारीख: With the formula entered in A2, =TODAY() returns the current date according to the computer’s date settings and updates when Excel recalculates. Format the result as a date if it appears as a number. TODAY does not store a fixed date of entry; use a static date instead if a record must not change over time.
Excel stores dates as serial values and applies number formats to display them as dates. If a date formula appears as a number, the value may be correct even though the cell is formatted as General or Number. Select the cell and choose Home > Number Format to apply a date format. For values that should remain fixed as dates rather than update, type the date directly or use a suitable date-entry method.
How to choose the right formula
Start by describing the task in ordinary language: “add all sales,” “count filled names,” “show Pass if the score reaches 50,” or “find the price for this product code.” Then match that task to the function’s job. This approach prevents a common mistake: choosing a familiar function and trying to force it to answer a different question.
- Use SUM for adding values and AVERAGE for the arithmetic mean.
- Use COUNT for numeric cells and COUNTA for non-empty cells.
- Use IF for one logical test and a choice between outcomes.
- Use COUNTIF or SUMIF when one condition controls a count or total.
- Use a lookup function when one value identifies a related value in another range.
- Use text or date functions when the task is to join, extract, or calculate with displayed information.
Also consider who will open the workbook. Newer functions such as XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Excel 2021 or Microsoft 365. LAMBDA, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, and HSTACK require Microsoft 365 or Excel 2024. If a recipient uses an older version, a newer function may show a #NAME? error for them. Check compatibility before sharing a workbook, especially in workplaces with mixed versions.
Common formula problems and how to fix them
A formula error often points to a mismatch between the formula and the data rather than a broken workbook. Check the function spelling, parentheses, separators, and the cell ranges before rewriting a long expression. Excel’s formula autocomplete can help confirm a function name and show the arguments it expects.
- #NAME? usually means Excel does not recognize part of the formula, such as a misspelled function name or text value without quotation marks. It may also appear when a workbook uses a function unavailable in an older Excel version.
- #VALUE! can indicate that a formula received a value of the wrong type, such as text where a calculation expects a number. Inspect the referenced cells for labels, stray spaces, or numbers stored as text.
- #N/A commonly appears when a lookup cannot find a match. Check for extra spaces, inconsistent codes, and whether the lookup range contains the requested value.
- Unexpected totals may result from selecting an incomplete range or including the wrong rows. Compare the formula’s range with the data and verify whether filtered or hidden rows should count for your purpose.
- A formula displays as text if the cell is formatted as Text or the entry begins with an apostrophe. Change the cell format to General, then edit and re-enter the formula.
Another common misconception is that a formula result is a permanently stored answer. Most formula results change when their input cells change. If a report needs a snapshot, preserve a copy of the workbook or, where appropriate, copy the calculated cells and use Paste Special > Values. Be careful: replacing formulas with values removes their live connection to the source data.
Building a reliable formula workflow
Good spreadsheet habits make formulas easier to read, audit, and maintain. Keep headers clear, place one kind of information in each column, and avoid combining several records in one cell. A tidy table makes it simpler to choose correct ranges and reduces mistakes when new rows are added.
- Write down what the result should mean, including how blanks and unusual cases should be treated.
- Identify the input cells and check that dates, numbers, and text are stored in appropriate forms.
- Enter a short formula and test it against a small example whose correct answer you can calculate manually.
- Copy the formula only after checking relative and absolute references.
- Review the result, including boundary cases such as a score exactly equal to a pass mark or a missing lookup code.
- Document important assumptions in a header, note, or nearby instruction so another person can understand the workbook.
For formulas that will be reused, Excel Tables can make data ranges easier to expand and formulas easier to read. Structured references use column names rather than only cell coordinates, but they require a properly formatted Excel Table. For a beginner, regular cell references are often easier to learn first; the main goal is to keep the formula’s inputs and purpose clear.
Frequently Asked Questions
What are the most useful Excel formulas for beginners?
Start with SUM, AVERAGE, COUNT, COUNTA, IF, COUNTIF, and SUMIF. Together, they cover addition, averages, counting, simple decisions, and totals based on a category. Add lookup and text functions when your work requires retrieving or joining information.
Are Excel formulas written in Hindi?
Many formula guides explain function meanings in Hindi while showing function names and syntax in English. The exact names accepted or displayed can depend on Excel’s language and version. If a formula from a guide is not recognized, search for the function in Excel’s formula autocomplete or Insert Function dialog.
Why does Excel show a formula instead of its answer?
The cell may be formatted as Text, the formula may begin with an apostrophe, or Excel may have Show Formulas enabled. Check the cell format and re-enter the formula; also check whether the workbook is displaying formulas rather than calculated results.
Can I use XLOOKUP in every version of Excel?
No. XLOOKUP is available in Microsoft 365 and Excel 2021 or later, but some older editions do not include it. If you share a workbook, confirm the recipient’s version or choose a lookup approach supported by that version.
Why does my formula use semicolons instead of commas?
Excel’s argument separator can depend on regional settings. The examples here use commas, but an installation configured for semicolons may require them in formulas. Follow the separator Excel accepts in your own formula bar.
Does TODAY save the date when I enter a record?
No. TODAY returns the current date and can update when the workbook recalculates. If you need a permanent record of a particular date, enter a fixed date rather than relying on TODAY.
Related
- Excel File With Table Filters: How to Add and Use Them
- Excel File Too Large? How to Make It Smaller in Excel
- Excel File Too Large to Email? Practical Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- XLOOKUP Multiple Criteria: Formula and ExamplesYes. In Excel for Microsoft 365 or Excel 2021 and later, XLOOKUP can match multiple criteria by multiplying…
- Excel Not Equal to Blank: Formulas, Examples, and FixesTo test whether a cell is not blank in Excel, use the not-equal operator with an empty string:…
- VLOOKUP in Excel: Return a Value from Another CellTo make VLOOKUP return a value from another cell, look up a key in the leftmost column of…
- Excel Date Plus 1 Month: Formula and Month-End RulesTo add one calendar month to a date in Excel, use the EDATE function: if the starting date…
- Excel Date Difference in Years: Formulas That WorkTo find the number of complete years between two dates in Excel, use =DATEDIF(A2,B2,"Y"), with the earlier date…
- Excel Timesheet: Calculate Hours Worked With FormulasTo calculate a shift in an Excel timesheet, put the start time in C2, end time in D2,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.