EXCEL FORMULAS

=SUM(X:X)                 Adding


THE X REPRESENTS A CELL
THE : REPRESENTS A RANGE OF CELLS

=========================================================================

 

=AVERAGE(X:X)       Averaging


=========================================================================

 

=(X*X)

 

=PRODUCT(X,X)        Multiply   2 ways


=========================================================================

 

 

=(X-X)

 

=SUM(X-X)                    Subtract   2 ways


=========================================================================

 

 

=(X/X)                             Divide

 

 


=QUOTIENT(X,X)
The Quotient function is only available if you have the Analysis ToolPak add-in installed. To install the Analysis ToolPak add-in select (Tools > Add-ins), select "Analysis ToolPak" and press OK. By design it does Not allow for remainders - it rounds down to the lowest whole integer.

 


=========================================================================

The VLOOKUP function

The VLOOKUP function is a handy one to know when you want Excel to lookup a value in one place and insert it in another. For example, let’s say you have a list of all of your customers on a sheet named “Accounts” and an invoice on another sheet named “Invoice”. When you type in their account number on the Invoice, you want Excel to fill in the name of the customer and their address (and this information is included for all customers on the Accounts sheet). A VLOOKUP will do this for you.

Since we want an exact match, type False in the Range_lookup field
=VLOOKUP(C2,Customers,2,FALSE)
C2 is the Look_up value; Customers is the Table_array; 2 is the Col_index_num