Spreadsheet Program Tips: Use Functions

Posted on 06. Mar, 2015 by in Bookkeeping Articles, MAC Tip, Small Business Tips, Windows Resources/Tips

Excel, Numbers and Sheets all share some of the function tasks allowing you to edit both text and accounting systemnumbers within their cells.

To add numbers across a range of cells use =SUM(RANGE).

To find the average of a range of numbers, =AVERAGE(RANGE).

If you would like to round a number to two decimal places, =ROUND(CELL,2).

Some functions you may not be aware of:

If you need to count all the numeric entries in a range, =COUNT(RANGE). Please note that if you have nonnumeric values, they will be overlooked. If you need to include, then the function is, =COUNTA(RANGE).

If you need to show the current date and time, =NOW: If using Excel and Sheets, you need to type, =NOW().

Need to see the lowest or highest values in a range, =MAX(RANGE) or =MIN(RANGE).

=TRIM(CELL) is helpful if you cut and paste text and you have extra spaces either at the beginning or the end of the block. This TRIM function removes all those extra spaces.

There are literally hundreds of functions available to you. To have a little fun and play around here is how you can find them. If you are using Numbers, when you type =, all the available functions appear in the right sidebar along with description and examples. Excel users, select View – Formula Builder  and those using Sheets, Help – Function list.

If you have some favorites not mentioned here, I would love to hear from you.

Tags: , , ,

Comments are closed.