Use the same formulas & calculations as in Excel.

Did you know that you can use the same formulas in calculation columns for SharePoint, as you do in Excel?

The trick is to remember that you are using fields, instead of cells, so fields must be surrounded by brackets ([ ]).

Example: =IF(OR([My Number]<[My Total],[Your Number]<[My Total]),”Yes”,”No”) – Underlined areas are column names, surrounded by brackets.

For more office techniques see our MS Office Tips.