Chapter 4. Predefined functions

Table of Contents

1. Date and time functions
1.1. datevalue
1.2. timevalue
1.3. datetimevalue
1.4. date
1.5. time
1.6. datetime
1.7. year
1.8. month
1.9. day
1.10. weekday
1.11. hour
1.12. minute
1.13. second
1.14. today
1.15. now
2. Logical functions
2.1. and
2.2. or
2.3. not
2.4. if
2.5. true
2.6. false
3. Mathematical functions
3.1. numbervalue
3.2. checknumber
3.3. sum
3.4. product
3.5. abs
3.6. acos
3.7. asin
3.8. atan
3.9. atan2
3.10. cos
3.11. cosh
3.12. sin
3.13. sinh
3.14. tan
3.15. tanh
3.16. degrees
3.17. radians
3.18. pi
3.19. exp
3.20. acosh
3.21. asinh
3.22. atanh
3.23. log
3.24. mod
3.25. ln
3.26. log10
3.27. sign
3.28. sqrt
3.29. trunc
3.30. int
3.31. rand
3.32. countif
3.33. sumif
3.34. round
3.35. rounddown
3.36. roundup
4. Spreadsheet functions
4.1. union
4.2. intersection
4.3. difference
4.4. apply
5. Statistical functions
5.1. avedev
5.2. stdev
5.3. var
5.4. max
5.5. min
5.6. average
5.7. count
6. Text functions
6.1. char
6.2. code
6.3. text
6.4. mid
6.5. left
6.6. right
6.7. trim
6.8. lower
6.9. upper
6.10. len
6.11. substitute
6.12. replace
6.13. find
6.14. search