IT:AD:Sharepoint:HowTo:Write Formulas
Examples
- =128+345 (addition)
- =5^2 (5 squared)
- =[Revenue] * 10/100
- =[Revenue] > [Cost] (returns Yes if Revenue Value is greater than [Cost]
- =AVERAGE(1,2,3,4,5)
- =MAX(10.00, [Amount]0.03) =DAY(…) (returns Day part of date as number (eg 31))