Overview

Functions in Excel may have 0 to n arguments:

• NA(), RAND()(), and NO W() have no arguments

• STANDARDIZE( Z) requires one argument

• COUNTIF(range, condition) requires two arguments

• IF(test, if-true, if-false) holds three arguments; if the last two are not provided, they return either true or false

• NORMDIST(X, mean, stdev, cumulative) requires four arguments

All functions return a value, which can be of several types (see Table - 31.):

• Integer (no decimals, up to 32,000)

• Long (no decimals, up to 2, 1 billion)

• Single (precision seven digits and/or decimals)

• Double (precision up to 15 digits and/or decimals)

• Date (number)

• Boolean (yes/no)

• String (text or formatted numbers)

Of course, you can always just type a function - but then you need to remember to start with an equal sign, to put in opening and closing parenthesis after the function name, and to use commas to separate arguments. Alternatively, you can use the f _x button on your toolbar or formula bar - then you...