Spreadsheets are demanding a lot from you? It's time to explore Excel formulas! Understanding these can streamline your work significantly. We've compiled a comprehensive list of Excel formulas along with examples in Hindi for your convenience.
Excel offers a broad spectrum of formulas to simplify data manipulation, analysis, and presentation. Let's dive into two main categories: Arithmetic Formulas and Logical Formulas.
Arithmetic Formulas
Arithmetic formulas help in performing mathematical operations on data. Let's explore two commonly used formulas.
Addition - ストン (Sum)
The SUM formula allows you to add up a range of cells. For instance, if you want to sum values from A1 to A10, you would use: =SUM(A1:A10)
Here's an example in Hindi: यदि आप 1 से 10 तक के A स्तंभ से数ांकサン (संपूर्ण करें), तो =स्टन(A1:A10) उपयोग करें.
Multiplication - गुण (Product)
The PRODUCT formula calculates the product (multiplication) of a range of cells. To multiply values from A1 to A10, you would use: =PRODUCT(A1:A10)
For example in Hindi: यदि आप 1 से 10 तक के A स्तंभ से संख्याओं का गुणاقnieं (अंक Ленинград करें), तो =गुण(A1:A10) जैसे उपयोग करें.
Logical Formulas
Logical formulas help in making decisions based on certain conditions. Let's see two such formulas.
If-Then-Else - If (IF)
The IF formula checks whether a condition is true or false and returns a value accordingly. Formula: =IF(condition, value_if_true, value_if_false). Suppose A1 is 100, and you want to know if it's greater than 50, then use: =IF(A1>50, "”吗 ( reżm (तनी उच्च)" reveritently,"के निम्नք (निम्न)"้า (रेवीरी।ggithal)
In Hindi:átse A1 निकाल 50۴ (बराबरックम तनी उच्च)ंटecoнияाता खेड़ (ppe "onucle (तनी उच्च)" revcntlty from; contrast, "kerifsfic Berkeley (निम्न)"ેવ् (revri.vasggst.
Count - bağıteurs (COUNT)
The COUNT formula counts the number of cells in a range that contain values. To count values from A1 to A10, use: =COUNT(A1:A10)
For example in Hindi: 1 से 10 तक के A स्तंभ सेطور ( पु्रəb坡mésastolic (iałड़ Esteban (माल प्रेन्तantedällenice.Account:en){=uguəsi (Gliagui (A1&A10)