-
Notifications
You must be signed in to change notification settings - Fork 0
/
formulas.html
922 lines (915 loc) · 77 KB
/
formulas.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
<div class="col-md-12">
<h1>SharePoint Calculated Column Functions List</h1>
<p>
If your are new to Calculated Column Formulas read the <a href="https://support.office.com/en-us/article/Introduction-to-data-calculations-94e1b4cc-cd1c-49c2-80ec-90c9b9591f47">Microsoft introduction to SharePoint Calculations</a>
</p>
<p>I collected this list from various resources. <a href="https://msdn.microsoft.com/en-us/library/office/bb862071%28v=office.14%29.aspx">MSDN Calculated Field Formulas</a> is incomplete, and sometimes even plain wrong. For example: The MSDN page says the MID function is not supported, but has been supported for a long time.
Multiple functions like <a href="https://support.office.com/en-US/article/SUBSTITUTE-function-b9dcfd8a-6bd8-4784-b128-dca79e4d0e02">SUBSTITUTE</a> state they work in SharePoint Online; but do not!<br>
Check <a href="https://support.office.com/en-US/article/excel-functions-by-category-9d1bdb2c-9fbd-4b9f-9a62-7b1c61c771da">this Microsoft list of Excel functions</a> if you are missing one in the list below. Be aware, this documentation is also not always correct.
</p>
<p>Most simple (hardly ever used) <a href="https://support.office.com/en-US/article/excel-functions-by-category-9d1bdb2c-9fbd-4b9f-9a62-7b1c61c771da#bmfinancial_functions">Financial functions</a> do work in Formula, I have omitted them for brevity.</p>
<p>I don't do questions/answers on this page. I will answer (allmost all) Calculated Column questions on <a href="http://sharepoint.stackexchange.com/questions/tagged/calculated-column">SharePoint/StackOverflow</a></p>
<p></p><h3>CalcMaster</h3>There is a <a href="https://github.com/Danny-Engelman/CalcMaster">Bookmarklet on GitHub</a><p></p> which hooks into the SharePoint Formula editor and does syntax checking and autosave.
<p></p><h3>ViewMasters</h3>Since SharePoint 2010 a Calculated Column set to datatype=Number can output HTML and JavaScript to a View; for details see my site <a href="../index.html#How">www.ViewMaster365.com</a><p></p>
<h3>Tested and tried Functions:</h3>
<style>
.functionlist {
font-size: 14px;
}
.functionlist th {
padding-left: 3px;
white-space: nowrap;
}
.functionlist td {
margin: 3px;
}
.functionlist_even {
background-color: lightgrey;
}
.functionlist_example {
font-weight: bold;
font-size: 0.8em;
}
.functionlist_description {
font-size: 0.9em;
}
.functionlist_usage {
font-size: 0.8em;
}
</style>
<div class="functionlist">
<table ts-wrapper="" class="ng-scope">
<thead>
<tr>
<th style="padding:0px 3px;width:90px;" ts-criteria="category|lowercase" ts-default="descending" class="tablesort-sortable tablesort-desc">Category</th>
<th ts-criteria="name|lowercase" ts-default="" class="tablesort-sortable tablesort-asc">Function</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr ng-repeat="function in Functionlist" ts-repeat="" ng-class-even="'functionlist_even'" class=" showIfLast"><td colspan="3"></td></tr><!-- ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/char-function-29f4329b-5e7e-436f-90a6-49cc10257770" target="_funcblank" class="ng-binding">CHAR ( asciivalue )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=CHAR ( 65 )</div>
<div class="functionlist_description ng-binding">Returns the character specified by a number (ASCII code)</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/CLEAN-function-25fa3c08-8d09-427a-88cc-599be36753c0" target="_funcblank" class="ng-binding">CLEAN ( string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=CLEAN ( "column" )</div>
<div class="functionlist_description ng-binding">Removes all nonprintable characters from a string</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/CODE-function-d56131d3-d0e1-46cd-8d18-4f8b2b35352f" target="_funcblank" class="ng-binding">CODE ( string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=CODE ("A")</div>
<div class="functionlist_description ng-binding">Returns the ASCII numeric code for the first character in a text string.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/concatenate-function-29892d52-053b-4b44-b257-a6e71a49fd53" target="_funcblank" class="ng-binding">CONCATENATE( str1 , [ .. , str30 ])</a>
</td>
<td>
<div class="functionlist_example ng-binding">=CONCATENATE( str1 , [ .. , str30 ])</div>
<div class="functionlist_description ng-binding">Join all parameters together as one string. & (ampersand) also works as string concatenation: str1 & str2 & str3</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/DOLLAR-function-f32d81bc-29e7-4f8d-9f5f-a6c7fc8e20b3" target="_funcblank" class="ng-binding">DOLLAR ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=DOLLAR ( "column" )</div>
<div class="functionlist_description ng-binding">Converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,##0.00_); ($#,##0.00). Use USDOLLAR Function to always use $ notation</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-CA/article/find-function-a75c7969-33b3-4660-962d-9db9be360bd1" target="_funcblank" class="ng-binding">FIND ( needle , haystack [ , start ] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=FIND ( "column" , "a string or column" [ , start_num ] )</div>
<div class="functionlist_description ng-binding">Returns the number of the character at which a specific character or text string is first found, beginning at start_num. !!Use SEARCH for NON Case-Sensitive searches!!</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/left-function-913824b4-fc42-4c8c-9229-0eaa57dcdf49" target="_funcblank" class="ng-binding">LEFT ( string [ , length ] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=LEFT ( 'applepie' , 5 )</div>
<div class="functionlist_description ng-binding">returns the first character or characters in a text string: apple, based on the number of characters you specify. Default is 1 character (apple)</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/len-function-038f2e0d-57d3-4f35-ae74-9a79d66e8fc2" target="_funcblank" class="ng-binding">LEN ( string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=LEN ('13 characters')</div>
<div class="functionlist_description ng-binding">returns the number of characters in a text string</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/LOWER-function-588db5d5-2c7f-4752-a9f7-0eb749ba47a5" target="_funcblank" class="ng-binding">LOWER ( string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=LOWER ( "Hello World!" )</div>
<div class="functionlist_description ng-binding">Converts text to lowercase. -> hello world!</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/mid-function-230833b1-28e7-4ef8-9286-eba06a3c29ad" target="_funcblank" class="ng-binding">MID ( string , position , length )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MID ( '6 applepies' , 3 , 5 )</div>
<div class="functionlist_description ng-binding">returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/PROPER-function-f0a33bd9-2dac-4531-a14e-3f28531c8976" target="_funcblank" class="ng-binding">PROPER( sentence string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=PROPER ( "hello world!" )</div>
<div class="functionlist_description ng-binding">Capitalizes the first letter in each word of a text value. Outputs: Hello World!</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/REPLACE-function-3e6288d2-faea-4764-95d4-39dd5e508321" target="_funcblank" class="ng-binding">REPLACE ( string , pos , length , new )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=REPLACE ( string , position , length , newtext )</div>
<div class="functionlist_description ng-binding"> replaces part of a text string, based on the number of characters you specify. Alas a Substitute function is not available in SharePoint, you have to use nested Replace calls.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/REPT-function-63ad109f-566a-4bb8-bfa2-f62d561e6923" target="_funcblank" class="ng-binding">REPT ( string , count )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=REPT ( "x" , 3 )</div>
<div class="functionlist_description ng-binding">Repeates an x 3 times to xxx</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/right-function-112699e2-fe7e-4cbf-8d1e-0e8db3884f26" target="_funcblank" class="ng-binding">RIGHT ( string [ , length ] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=RIGHT ( 'applepie' , 3 )</div>
<div class="functionlist_description ng-binding">returns the last characters in a text string, based on the number of characters you specify (pie)</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-us/article/ROMAN-function-0806bbc1-743d-44b8-9d19-6df51af49f6f" target="_funcblank" class="ng-binding">ROMAN ( year , [form] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=ROMAN (2015, [form] )</div>
<div class="functionlist_description ng-binding">Converts an arabic numeral to roman, as text.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/SEARCH-function-c0391ab0-be44-4519-ba51-90cc8df12748" target="_funcblank" class="ng-binding">SEARCH ( needle , haystack [ , start ] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=SEARCH ( "column" , "a string or column" [ , start_num ] )</div>
<div class="functionlist_description ng-binding">Returns the number of the character at which a specific character or text string is first found, beginning at start_num. !! Use FIND for Case-Sensitive searches!!</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-US/article/T-function-c6c94e6c-6624-4ed0-b2aa-ca93403f864c" target="_funcblank" class="ng-binding">T ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=T ( "2100")</div>
<div class="functionlist_description ng-binding">If value is text, T returns value. If value does not refer to text, T returns a empty textstring. So T( 2100 ) returns an empty string.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/text-function-b569b076-1851-4d55-9b38-71d58dee2458" target="_funcblank" class="ng-binding">TEXT ( date/number , format )</a>
</td>
<td>
<div class="functionlist_example ng-binding">TEXT ([DateTimeField],'format')</div>
<div class="functionlist_description ng-binding">Prints a DateTime field as text</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT ([DateTimeField],'hh:mm:ss')</td>
<td class="ng-binding">Time Only</td>
<td class="ng-binding">08:21:35</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT ([DateTimeField],'dddd')</td>
<td class="ng-binding">Weekday</td>
<td class="ng-binding">Tuesday</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT ([DateTimeField],'ddd')</td>
<td class="ng-binding">Weekday abbriavted</td>
<td class="ng-binding">Tue</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT ([DateTimeField],'mmmm')</td>
<td class="ng-binding">Month</td>
<td class="ng-binding">January</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT ([DateTimeField],'mmm')</td>
<td class="ng-binding">Month abbreviated</td>
<td class="ng-binding">Jan</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT ([DateTimeField],'yyyy')</td>
<td class="ng-binding">Year</td>
<td class="ng-binding">2015</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT ([DateTimeField],'yyy')</td>
<td class="ng-binding">Year abbreviated</td>
<td class="ng-binding">15</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT ([DateTimeField],'mmmm dd, yyyy')</td>
<td class="ng-binding"></td>
<td class="ng-binding">January 21, 2015</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT (3.1415679,'000')</td>
<td class="ng-binding"></td>
<td class="ng-binding">21.1</td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/TRIM-function-50b6f593-4801-4f06-81c5-3345e7f80ddd" target="_funcblank" class="ng-binding">TRIM ( string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=TRIM ( " column " )</div>
<div class="functionlist_description ng-binding">Removes/trims spaces at beginning and end of a string -> 'column'</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/UPPER-function-3f91b8ab-86fd-45c4-94c1-586a2201ca09" target="_funcblank" class="ng-binding">UPPER ( string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=UPPER ( "Hello World!" )</div>
<div class="functionlist_description ng-binding">Converts text to uppercase. -> HELLO WORLD!</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Text</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/VALUE-function-ffd3988a-7751-46de-88e3-b63aa1e18606" target="_funcblank" class="ng-binding">VALUE ( numberstring )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=VALUE ( "2100")</div>
<div class="functionlist_description ng-binding">Converts a text string that represents a number to a number, returns #VALUE! on error</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/and-function-78956048-53c7-484a-ab0b-6e70d7f03400" target="_funcblank" class="ng-binding">AND ( value1 , value2 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=AND ( [Col]>9 , [Col]<12 )</div>
<div class="functionlist_description ng-binding">Returns the logical value TRUE if all of the arguments are TRUE; returns FALSE if one or more arguments is FALSE. Maximum of 30 parameters.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/CHOOSE-function-f981a30c-634b-4d6d-896e-1495f0a91e89" target="_funcblank" class="ng-binding">CHOOSE ( index , value1 [ .. , value29] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=CHOOSE (2 , [Col1] , [Col2] , ... , [Col29] )</div>
<div class="functionlist_description ng-binding">Will return Col2 (the index number) to a maximum of 29 Choices (first parameter is the index selector)</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/exact-function-d9b15b16-ca1e-4cd3-952f-cf02a4d78010" target="_funcblank" class="ng-binding">EXACT ( string , string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">EXACT ( "Hello World" , "HELLO WORLD")</div>
<div class="functionlist_description ng-binding">Compares two text strings and returns the logical value TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/IF-function-0a4ad187-dba3-48ae-abe9-bbe3aa6aebca" target="_funcblank" class="ng-binding">IF ( condition , true , false )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=IF ([Column1]=15, "OK", "Not OK")</div>
<div class="functionlist_description ng-binding">If the value in Column1 equals 15, return the string OK</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/IS-functions-586532cc-9888-4ca0-98b8-c874e4c8a087" target="_funcblank" class="ng-binding">ISBLANK ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=ISBLANK ( column )</div>
<div class="functionlist_description ng-binding">Returns TRUE/YES for value not defined or an empty string</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-ca/article/IS-functions-586532cc-9888-4ca0-98b8-c874e4c8a087" target="_funcblank" class="ng-binding">ISERROR( calculation )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=IF (ISERROR ([Column1]/[Column2]), "Invalid Calculation", [Column1]/[Column2])</div>
<div class="functionlist_description ng-binding">Returns the text Invalid Calculation if the calculation value is an error, or execute the calculation when valid. Use ISERR() to testfor all errors except #N/A</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/IS-functions-586532cc-9888-4ca0-98b8-c874e4c8a087" target="_funcblank" class="ng-binding">ISEVEN ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">ISEVEN ( [Column] )</div>
<div class="functionlist_description ng-binding">Returns TRUE if number is even, or FALSE if number is odd.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/IS-functions-586532cc-9888-4ca0-98b8-c874e4c8a087" target="_funcblank" class="ng-binding">ISLOGICAL ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">ISLOGICAL ( value )</div>
<div class="functionlist_description ng-binding">Returns TRUE if value is a boolean True (Yes/No columns)</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/IS-functions-586532cc-9888-4ca0-98b8-c874e4c8a087" target="_funcblank" class="ng-binding">ISNA ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=ISNA ( column )</div>
<div class="functionlist_description ng-binding">Tests if value is a N/A Error value</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/IS-functions-586532cc-9888-4ca0-98b8-c874e4c8a087" target="_funcblank" class="ng-binding">ISNONTEXT ( value/string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">ISNONTEXT ( [Column] )</div>
<div class="functionlist_description ng-binding">Returns Yes if Column is Not a Text. Note: This function returns Yes for Blank values; the Function ISNUMBER returns No for Blank values</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/IS-functions-586532cc-9888-4ca0-98b8-c874e4c8a087" target="_funcblank" class="ng-binding">ISNUMBER ( value/string )</a>
</td>
<td>
<div class="functionlist_example ng-binding">ISNUMBER ( [Column] )</div>
<div class="functionlist_description ng-binding">Returns Yes if Column is a Number. Note: This function returns No for Blank values; the Function ISNONTEXT returns Yes for Blank values</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/IS-functions-586532cc-9888-4ca0-98b8-c874e4c8a087" target="_funcblank" class="ng-binding">ISODD ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">ISODD ( [Column] )</div>
<div class="functionlist_description ng-binding">Returns TRUE if number is odd, or FALSE if number is even.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/NOT-function-1baed918-9af4-4819-9364-0b203eefbb0c" target="_funcblank" class="ng-binding">NOT ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=NOT (15+9=24)</div>
<div class="functionlist_description ng-binding">Returns Yes or No (True/False) for a given statement. Is 15 plus 9 not equal to 24? (No)</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Logic</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/or-function-9a2a1cca-696f-4d19-a959-3943babd076f" target="_funcblank" class="ng-binding">OR ( value1 , value 2 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=OR (15>9, 15<8)</div>
<div class="functionlist_description ng-binding">Returns Yes if any argument is TRUE; returns No if all arguments are FALSE.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/DATE-function-555f577e-06bf-4f30-a1c3-f6a4ba0e09be" target="_funcblank" class="ng-binding">DATE ( year , month , day )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=DATE ( YEAR ([Column1]) , MONTH ([Column1])+3 , DAY ([Column1]) )</div>
<div class="functionlist_description ng-binding">Returns a DateValue for given Year, Month, Day. Adds 3 months to the date in Column1</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/datedif-function-bd549d1c-f829-4691-a77d-4a1e3d42bc1a" target="_funcblank" class="ng-binding">DATEDIF ( date , date , unit )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=DATEDIF ([Column1],[Column2],'d')</div>
<div class="functionlist_description ng-binding">Returns the difference in days between dates in columns 1 and 2. 3rd parameter can be 'ym' or 'yd' to count the months or day excluding the year part.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/DATEVALUE-function-3c867970-72e8-442e-adbf-bb7493a27a5c" target="_funcblank" class="ng-binding">DATEVALUE ( date )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=DATEVALUE ('12/31/2015')</div>
<div class="functionlist_description ng-binding">Converts a date that is stored as text to a Date serial number</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/DAY-function-9dc6d468-28b5-4ada-93c5-2e2541a3b80f" target="_funcblank" class="ng-binding">DAY ( date )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=DAY ([Column1])</div>
<div class="functionlist_description ng-binding">Returns the day number 21 if Column is 11/21/2014</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/DAYS360-function-c039d347-dde0-4582-8949-7b4871b82715" target="_funcblank" class="ng-binding">DAYS360 ( date1 , date2 )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=DAYS360 ()</div>
<div class="functionlist_description ng-binding">returns the number of days between two dates based on a 360-day year (twelve 30-day months) used in some accounting calculations.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/hour-function-e2833b50-0db0-499b-acc5-e9ae03de8fbb" target="_funcblank" class="ng-binding">HOUR ( date )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=IF ( HOUR ([DateTimeField]) < 12 , 'AM' , 'PM')</div>
<div class="functionlist_description ng-binding">Returns the Hour value</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=IF ( AND ( HOUR ([DateTimeField])<18 , HOUR ([DateTimeField])>6 ) , 'day' , 'night')</td>
<td class="ng-binding">Test if time is between 6am and 18pm</td>
<td class="ng-binding">day</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=HOUR ( [Column1]-[Column2] ) </td>
<td class="ng-binding">Hours between two times, !when the difference does not exceed 24!</td>
<td class="ng-binding"></td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=INT ( ( [Column2] - [Column1] ) * 24)</td>
<td class="ng-binding">Total hours between two times</td>
<td class="ng-binding"></td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">= ( [Column1] - INT ( [Column1] ) ) *24 </td>
<td class="ng-binding">Convert hours from the standard time format to a decimal number</td>
<td class="ng-binding">When Column1=11:35 AM, returns the number of hours since 12:00</td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/MINUTE-function-24b9ed94-0d9e-407f-99e8-52e320d04cfd" target="_funcblank" class="ng-binding">MINUTE ( date )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=IF ( HOUR ([DateTimeField]) < 12 , 'AM' , 'PM')</div>
<div class="functionlist_description ng-binding">Returns the Minute value</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=MINUTE ( [Column2] - [Column1] )</td>
<td class="ng-binding">Minutes between two times, !when the difference does not exceed 60!</td>
<td class="ng-binding"></td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=INT ( ( [Column2] - [Column1] ) * 1440 )</td>
<td class="ng-binding">Total Minutes between two times</td>
<td class="ng-binding"></td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/month-function-5a5f1424-303c-4128-97be-9bc39e037681" target="_funcblank" class="ng-binding">MONTH ( date )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MONTH ([Column1])</div>
<div class="functionlist_description ng-binding">Returns the month 11 if Column is 11/21/2014</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-US/article/NOW-function-b3062c60-8a32-4fb3-a2ea-a77e1506920a" target="_funcblank" class="ng-binding">NOW ()</a>
</td>
<td>
<div class="functionlist_example ng-binding">=NOW ()</div>
<div class="functionlist_description ng-binding">Returns the serial number of today's date + time. Note! See Today()</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/SECOND-function-0023c933-e809-4bee-8dc5-00d965e28640" target="_funcblank" class="ng-binding">SECOND ( date )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=IF ( HOUR ([DateTimeField]) < 12 , 'AM' , 'PM')</div>
<div class="functionlist_description ng-binding">Returns the Seconds value</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=SECOND ( [Column2] - [Column1] )</td>
<td class="ng-binding">Seconds between two times, !when the difference does not exceed 60!</td>
<td class="ng-binding"></td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=INT ( ( [Column2] - [Column1] ) * 86400 )</td>
<td class="ng-binding">Total Seconds between two times</td>
<td class="ng-binding"></td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-US/article/TODAY-function-3201fcb2-7343-4016-8e95-f31391eb4f88" target="_funcblank" class="ng-binding">TODAY ()</a>
</td>
<td>
<div class="functionlist_example ng-binding">=TODAY ()</div>
<div class="functionlist_description ng-binding">Returns the serial number of today's date. Note! The SharePoint TODAY Constant can not be used in Formulas and the TODAY() function will only re-calculated WHEN the Item is updated by a user (or a Workflow!). So it can not be used for day calculations as it does in Excel!</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/WEEKDAY-function-e5dbebc7-5818-48f8-90c0-7e7129e138d2" target="_funcblank" class="ng-binding">WEEKDAY ( date )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=WEEKDAY ([DateField],[startday])</div>
<div class="functionlist_description ng-binding">Returns the sequential number of a given date. Optional startday=1 (default) starts week on sunday=1; startday=2 week starts on monday (so sunday=7); startday=3 week starts on tuesday (sunday=6). MSDN documentation list more values, they are not valid in SharePoint.</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=[Today] + (6 - MOD(WEEKDAY([Today]),7)) + 7</td>
<td class="ng-binding"> Next Friday</td>
<td class="ng-binding">Next Friday</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">TEXT (WEEKDAY ([DateField]),'ddd')</td>
<td class="ng-binding"> (abbreviated) Name of a weekday</td>
<td class="ng-binding">Mon</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">WEEKDAY (DATE (YEAR ([DateField]),1,1))</td>
<td class="ng-binding">name of january 1st</td>
<td class="ng-binding">Monday</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">ROUNDDOWN ( ([DateField]-DATE (YEAR ([DateField]),1,1)+WEEKDAY (DATE (YEAR ([DateField]),1,1))-WEEKDAY ([DateField]+1)/7,0)+1</td>
<td class="ng-binding">Shows the weeknumber (US Style)</td>
<td class="ng-binding">5</td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Date</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/year-function-4db82426-8590-4a56-a057-2f19ff38501e" target="_funcblank" class="ng-binding">YEAR ( date )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=YEAR ([Column1])</div>
<div class="functionlist_description ng-binding">Returns the fullyear 2014 if Column is 11/21/2014</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/average-function-73cdedbf-5954-492d-a32d-aa9fbc29c5ec" target="_funcblank" class="ng-binding">AVERAGE ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=AVERAGE ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Average of the values of three columns.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/COUNT-function-62f581de-762e-4c5a-b88e-a2a29a8ac081" target="_funcblank" class="ng-binding">COUNT ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=COUNT ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Counts the number of columns that contain Numeric values. Excluding Date,Text and Null/Blank,Error or Logical values See COUNTA for counting Text values</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/counta-function-4c35510e-bdce-4135-a20e-23c9698a22ea" target="_funcblank" class="ng-binding">COUNTA ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=CHOOSE ( [Col1] , [Col2] , [Col3] , [Col4] , ... , [Col30] )</div>
<div class="functionlist_description ng-binding">counts the number of cells that are not empty in a range. Maximum of 30 columns</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/even-function-61a90d63-fcb5-48ac-bcc8-29b09492ea78" target="_funcblank" class="ng-binding">EVEN ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=EVEN ( [Column1] )</div>
<div class="functionlist_description ng-binding">Rounds Up to the nearest Even number, Even ( 12.4 ) -> 14</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-sg/article/FIXED-function-774fc7b8-9dc9-4dc6-a5e4-3d1924a9123a" target="_funcblank" class="ng-binding">FIXED ( value , decimals , T/F )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=FIXED ( [Column] , Nr , optional: TRUE )</div>
<div class="functionlist_description ng-binding">Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. The optional TRUE value prevents from including commans in the returned text.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef" target="_funcblank" class="ng-binding">INT ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=INT ( [Column1] )</div>
<div class="functionlist_description ng-binding">Rounds a number Down to the nearest integer</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/max-function-ffb82196-748c-49d9-916a-86aca191b669" target="_funcblank" class="ng-binding">MAX ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MAX ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Returns the Largest value of all columns. Use MAXA to include True (1) or False and Text values (0)</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/maxa-function-05b9cde0-761f-48cf-a23f-d82cd5f8984d" target="_funcblank" class="ng-binding">MAXA ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MAXA ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Returns the Largest value of all columns.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/MEDIAN-function-ea66592d-8df3-4e66-945c-75740408ddf0" target="_funcblank" class="ng-binding">MEDIAN ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MEDIAN ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Median of the values of all columns.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/min-function-082f190d-6bb2-44e5-9fd2-db591dbec01b" target="_funcblank" class="ng-binding">MIN ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MIN ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Returns the smallest value of all columns. Use MINA to INclude Logical and Text values.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/MINA-function-c33ba187-ab51-4719-898b-33384a884406" target="_funcblank" class="ng-binding">MINA ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MINA ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Returns the smallest value of all columns. Use MIN to EXclude Logical and Text values.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3" target="_funcblank" class="ng-binding">MOD ( value , divisor )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MOD ( 7 , 4 )</div>
<div class="functionlist_description ng-binding"> (Modulo) Returns the remainder after number is divided by divisor. The result has the same sign as divisor.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-us/article/MODE-function-3903cb1a-808d-4341-8962-1f8e82b20df1" target="_funcblank" class="ng-binding">MODE ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=MODE ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Returns the most frequently occurring, or repetitive, value in the argument list.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/odd-function-42f9a5b4-9e7c-4cb8-b43c-a5c7cbcb6270" target="_funcblank" class="ng-binding">ODD ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=ODD ( [Column1] )</div>
<div class="functionlist_description ng-binding">Rounds Up to the nearest Odd number, Odd ( 12.4 ) -> 13</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/power-function-bad07d5a-d787-48a5-9e72-853a5eb0e515" target="_funcblank" class="ng-binding">POWER ( value , power )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=POWER ( 5 , 3 )</div>
<div class="functionlist_description ng-binding">Same as: 5^3 , Calculates 5x5x5</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/product-function-15e03c4a-a347-4f4c-a87a-9197d59f5abb" target="_funcblank" class="ng-binding">PRODUCT ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=PRODUCT ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Muliplies multiple value.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/round-function-63f021ed-c38f-483d-b0a4-44403026131b" target="_funcblank" class="ng-binding">ROUND ( value [ , decimals ] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=ROUND ( [Column1] [ , decimals ] )</div>
<div class="functionlist_description ng-binding">Rounds Up or Down to the nearest fraction with optional decimal.</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUND ( 20.3 )</td>
<td class="ng-binding">Rounds Down because .3 is less than .5</td>
<td class="ng-binding">20</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUND ( 5.9 )</td>
<td class="ng-binding">Rounds Up because .9 is greater than .5</td>
<td class="ng-binding">6</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUND ( -5.9 )</td>
<td class="ng-binding">Rounds Down because -.9 is less than -.5</td>
<td class="ng-binding">-6</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUND ( -5.3987 , 1 )</td>
<td class="ng-binding">Rounds Up because -.3 is greater than -.5</td>
<td class="ng-binding">-5.3</td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/rounddown-function-2ac18feb-4f2d-4f0f-bd67-e6327d896d1f" target="_funcblank" class="ng-binding">ROUNDDOWN ( value [ , decimals ] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=ROUNDDOWN ( [Column1] [ , decimals ] )</div>
<div class="functionlist_description ng-binding">Rounds Down to the nearest number with optional decimal.</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUNDDOWN ( 20.34 )</td>
<td class="ng-binding">nearest number</td>
<td class="ng-binding">20</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUNDDOWN ( 20.34 , 1 )</td>
<td class="ng-binding">nearest number</td>
<td class="ng-binding">20.3</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUNDDOWN ( -5.9 )</td>
<td class="ng-binding">nearest number (incorrect -6 in MSDN!)</td>
<td class="ng-binding">-5</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUNDDOWN ( 12.5493 , 2 )</td>
<td class="ng-binding">nearest number</td>
<td class="ng-binding">12.54</td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/roundup-function-a92985d9-f99a-4ed4-9fd4-ad6e1d6f10b7" target="_funcblank" class="ng-binding">ROUNDUP ( value [ , decimals ] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=ROUNDUP ( [Column1] [ , decimals ] )</div>
<div class="functionlist_description ng-binding">Rounds Up to the nearest number with optional decimal.</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUNDUP ( 20.3 )</td>
<td class="ng-binding">nearest number</td>
<td class="ng-binding">21</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUNDUP ( -5.9 )</td>
<td class="ng-binding">nearest number (incorrect -5 in MSDN!)</td>
<td class="ng-binding">-6</td>
</tr><!-- end ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=ROUNDUP ( 12.5493 , 2 )</td>
<td class="ng-binding">nearest number</td>
<td class="ng-binding">12.55</td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-us/article/SIGN-function-0050bda1-6483-4601-bd38-a7e859314d52" target="_funcblank" class="ng-binding">SIGN( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=SIGN ( -7 )</div>
<div class="functionlist_description ng-binding">Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/sum-function-c53f1b99-6aef-4622-b2aa-45f924727b37" target="_funcblank" class="ng-binding">SUM ( value1 , [ .. , value30] )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=SUM ( [Column1] , [Column2] , ... , [Column30] )</div>
<div class="functionlist_description ng-binding">Adds the values of three columns.</div>
<!-- ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun --><tr ng-repeat="function in Functionlist | tablesortOrderBy:sortFun" ng-class-even="'functionlist_even'" class="ng-scope functionlist_even">
<td style="padding:0px 3px;white-space:nowrap;vertical-align:top;text-align:center;" class="ng-binding">Calc</td>
<td style="white-space:nowrap;vertical-align:top;font-size:1.1em;"><a href="https://support.office.com/en-SG/article/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef" target="_funcblank" class="ng-binding">INT ( value )</a>
</td>
<td>
<div class="functionlist_example ng-binding">=TRUNC ( [Column1] )</div>
<div class="functionlist_description ng-binding">Truncates a number</div>
<!-- ngIf: function.Usage --><div ng-if="function.Usage" class="functionlist_usage ng-scope">
<table>
<thead>
<tr><th>Formula</th>
<th>Description</th>
<th>Output</th>
</tr></thead>
<tbody>
<!-- ngRepeat: usage in function.Usage --><tr ng-repeat="usage in function.Usage" class="ng-scope">
<td class="ng-binding">=TRUNC ( 1.6 )</td>
<td class="ng-binding"></td>
<td class="ng-binding">1</td>
</tr><!-- end ngRepeat: usage in function.Usage -->
</tbody>
</table>
</div><!-- end ngIf: function.Usage -->
</td>
</tr><!-- end ngRepeat: function in Functionlist | tablesortOrderBy:sortFun -->
</tbody>
</table>
</div>
</div>