*** 7 USEFUL FUNCTIONS IN EXCEL 1. Count - to count the number - TopicsExpress



          

*** 7 USEFUL FUNCTIONS IN EXCEL 1. Count - to count the number of highlighted cells with content. 2. Countif ** - conditional count function 3. ABS - mathematical function to display absolute value of figure (i.e whether negative/positive) 4. Now() - to display current date 5. Date - to input date into cell 6. SumIF * (usually works with two ranges, i.e. data range, criteria & selection/sum range) e.g. =SUMIF(A2:A5,">160000",B2:B5)... 7. SumIFs - (SUMIF function with multiple criteria) - MORE COMPLEX FUNCTION
Posted on: Tue, 17 Sep 2013 11:48:12 +0000

Trending Topics



Recently Viewed Topics




© 2015