Excel 2010 Formulas In Hindi Pdf

??? ?????? Excel 2010 Formulas ????? ??? ?????????? ???:

1. SUM Formula (??? ?????): ?? ????? ?? ????? ???? ?? ???? ???? (range) ?? ??? ???????? ?? ??? (sum) ????? ???? ????

Syntax: =SUM(range)

??????: =SUM(A1:A10)

2. AVERAGE Formula (??? ?????): ?? ????? ?? ????? ???? ?? ???? ???? (range) ?? ??? ???????? ?? ??? (average) ????? ???? ????

Syntax: =AVERAGE(range)

??????: =AVERAGE(A1:A10)

3. MAX Formula (?????? ?????): ?? ????? ?? ????? ???? ?? ???? ???? (range) ??? ???? ???? ?????? (maximum number) ????? ???? ????

Syntax: =MAX(range)

??????: =MAX(A1:A10)

4. MIN Formula (??????? ?????): ?? ????? ?? ????? ???? ?? ???? ???? (range) ??? ???? ???? ?????? (minimum number) ????? ???? ????

Syntax: =MIN(range)

??????: =MIN(A1:A10)

5. IF Formula (??? ?????): ?? ????? ?? ????? ???? ?? ???? ???? (condition) ?? ???? ?? ?? ?? ?????? ???????? (options) ??? ?? ?? ??? ???? ????

Syntax: =IF(condition, result if true, result if false)

??????: =IF(A1>10, "Greater than 10", "Less than or equal to 10")

?? ????? ?? ??? ?? ?????? ???? ?? ?? A1 ?? 10 ?? ???? ??? ???? ?????? (decision) ?? ?????? ????? ??? A1 10 ?? ???? ?? ?? ?? "Greater than 10" ????, ?????? "Less than or equal to 10" ?????

6. COUNT Formula (????? ?????): ?? ????? ?? ????? ???? ?? ???? ???? (range) ??? ????? (present) ???????? ?? ?????? (count) ????? ???? ????

Syntax: =COUNT(range)

??????: =COUNT(A1:A10)

?????? ?? ?? ?? Excel 2010 Formulas ????? ??? ???? ??? ?????? ????? ??? ??????