Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

NOT(logical) [Category: Logical]

Reverses the value of its argument. Use NOT when you want to make sure

a value is not equal to one particular value. Guru Tip: Sometimes you write a

logical expression that is returning TRUE when it should be returning FALSE.

Reverse the TRUE/FALSE by using NOT. Also great for creating NAND logic;

=NOT(AND(condition 1, condition 2)).

NOW( ) [Category: Date & Time]

Returns the serial number of the current date and time. Guru Tip: =NOW() will

return the date and time of the last calculation of the worksheet. The cell does

not update every second unless you are pressing F9 to recalculate every second

(or entering numbers in other cells every second). While NOW is popular, you

should consider =TODAY() instead if you need to calculate the number of days

from now until a due date.

NPER(rate, pmt, pv, fv, type) [Category: Financial]

Returns the number of periods for an investment based on periodic, constant

payments and a constant interest rate.