Excel Formulas
|
Function
|
Formula
|
Example
|
|
To add up the total
|
=SUM(cell range)
|
=SUM(B2:B9)
|
|
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
|
|
Average
|
=AVERAGE(cell range)
|
=AVERAGE(B2:B9)
|
|
Percentage
|
|
=G4/HG*100
|
|
Max
|
=MAX(cell range)
|
=MAX(B2:B9)
|
|
Min
|
=MIN(cell
range)
|
=MIN(B2:B9)
|
|
Count IF
|
=COUNTIF(range,value)
|
=COUNTIF(D5:D11,”red”)
|
|
IF
|
|
=IF(F2>=90,"A+",IF(F2>=80,"A",IF(F2>=70,"B+",IF(F2>=60,"B",IF(F2>=50,"C","F")))))
|
|
Enter Time
|
Ctrl +Shift :
|
8:40 AM
|
|
Enter Date
|
Ctrl ;
|
01/02/2019
|
Simple formatting tricks
|
Function
|
Formula
|
Example
|
|
To
change a cell to proper case
|
=PROPER(cell)
|
=PROPER(A2)
|
|
To change a cell to upper
case
|
=UPPER(cell)
|
=UPPER(A2)
|
|
To change a cell to lower case
|
=LOWER(cell)
|
=LOWER(A2)
|
No comments:
Post a Comment