Basic Excel Formulas

Last update on June 19, 2009 10:56 AM by jak58
Published by netty5

Basic Excel Formulas










Below are some basic formulas for Microsoft excel:
Basic formula :
ADDITION cell A1 to A10 = sum (A1: A10)
  • AVERAGE cell A1 to A10 = average (A1: A10)
  • MAXIMUM cell A1 to A10 = max (A1: A10)
  • MINIMUM cell A1 to A10 = min (A1: A10)


On an excel sheet, there are many formulas under the cells all over the sheet .You can however select them from column by doing this:
sum = (A1, A3; C4)

IF Function:

The IF function is very easy and interesting for performing: 


= IF (condition; value "if true"; value "otherwise")


Example:

IF(A1 <= 0; "ordering", "stock")
This would mean: If the contents of cell A1 is less than or equal to zero, then it displays "to order", otherwise (if the contents of cell A1 is greater than zero) on display "at stock".


Freeze a cell:

Once the cell written press F4 to see the details of the cell and dollars.
Best answers for « Basic Excel Formulas » in :
Basic Excel Formulas 2 Show Basic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
Excel formula to get the cell with the text Show
Excel Formula Show
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Unlimited Conditional Formatting ShowUnlimited Conditional Formatting Introduction Principle Code Introduction The limitation of MFC (Conditional Formatting) to Excel version 2007 is less than 3. This is very short. Having seen many applications to push the limit, I am...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
They need your help