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”)

For more SharePoint techniques, take a class with AdvantEdge Training & Consulting!