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

Previous Post Next Post