Basic math
To add up the total:
Use this formula =SUM(cell range)
Inside the "()" you write cell range.
Example:- If you want to know about Jhon and Natashas Salary.
=SUM(B2:B3)
Hare is|| B=Slary column
2=Jhons Number &
3=Natashas Number
So "=SUM(B2:B9)" is the formula of Jhon and Natashas Total Salary.
Then Enter
Total = 3000
To add individual items =Value1 + Value 2 =B2+C2
Subtract =Value1 - Value 2 =B2-C2
Multiply =Value1 * Value2 =B2*C2
Divide =Value1 / Value2 =B2/C2
Exponents =Value1 ^ Value2 =B2^C2
Average =AVERAGE(cell range) =AVERAGE(B2:B9)
Median =MEDIAN(cell range) =MEDIAN(B2:B9)
Max =MAX(cell range) =MAX(B2:B9)
Min =MIN(cell range) =MIN(B2:B9)
S
Post a Comment