Скачать или смотреть Excel Average & Percentage | Basic Function Explain Hindi | Average/Percentage Formula Use Hindi |

#sumittechnology #Sumittechnology #Sumitsir #technology #sumityadav #Sumitsirexcel #sumityadav #computertips #Explore #computerknowledge
Excel Average & Percentage | Basic Function Explain Hindi | Average/Percentage Formula Use Hindi | #Average&percentage #formula

In Excel, you can use the AVERAGE function to calculate the average of a range of cells, and the PERCENTAGE function to calculate a percentage based on a given value. Here's how you can use these functions:

AVERAGE Function:
The AVERAGE function calculates the average of a range of numbers.
Syntax:
excel
=AVERAGE(number1, [number2]
Example:
If you have a range of numbers in cells A1 to A5, you can calculate the average as follows:
excel
=AVERAGE(A1:A5)
PERCENTAGE Function:
In Excel, there is no specific PERCENTAGE function, but you can calculate a percentage using a formula.

Syntax:
excel
=(part/whole)*100
Example:
If you want to calculate the percentage of the value in cell A1 compared to the total in cell B1:
excel
=(A1/B1)*100

Downlode Practice File Excel :- https://docs.google.com/spreadsheets/...


Using a Cell Reference for Percentage:

You can also use a cell reference for the percentage calculation. For example, if you have the percentage value in cell C1, and you want to calculate the actual value based on a total in cell B1:

excel
=(C1/100)*B1
```