Formulae in Excel

Each Excel formula must begin with an equal sign ( = )

Note:  A single quote ( ' ) at the beginning of the content of a cell indicates that what follows is a text string and there is nothing to calculate.

To get the total =Sum(Cell# : cell#)    OR   = Sum(column# : column#) 
Example: Sum(H4:H48)

To multiply = first cell to be multiplied*second cell to be multiplied then enter
=Cell# * cell#      OR       =column# * column#  
Example:  =K3*K4

To import data from another worksheet
=‘title of worksheet’!column# 
example =’title of worksheet’!J3

 

SUM	=SUM(Cell#:Cell#)
AVERAGE	=AVERAGE(Cell#:Cell#)
MAX	=MAX(Cell#:Cell#)
MIN	=MIN(Cell:Cell#)
SQRT (root value)	=SQRT(Cell#)
Apply AutoSum	ALT+= (twice)
Current date	CTRL+;
Current time	CTRL+:
Spelling	F7
Help	F1
Macros	ALT+F8