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.