| A | B |
|---|
| SQRT | displays square root of number identified in argument |
| ROUND | displays rounded value of number to number of places designated by second argument |
| LN | displays natural logarithm of number |
| AVERAGE | displays average of range identified in argument |
| COUNT | displays number of cells with numerical values in argument range |
| MAX | displays largest number contained in range identified in argument |
| MIN | displays smallest number contained in range identified in argument |
| STDEV | displays standard deviation of numbers contained in argument range |
| VAR | displays variance for numbers contained in argument range |
| SUM | adds all numbers in cell range |
| FV | displays future value of series of equal payments |
| PV | displays present value of series of equal payments |
| PMT | displays payment period needed to repay loan |
| DATE | displays date in variety of formats |
| NOW | displays the current date or time based on computer's clock |
| REPT | displays text in first argument a specified number of times according to second argument |
| IF | checks whether condition is met, and returns one value if TRUE and another value if FALSE |
