Microsoft Office Tutorials and References
In Depth Information
Exhibit 4.7
IF function conversion to payments categories
left to right, the function first tests the condition—is the C2 cell content less than or
equal to 250? If the answer is yes (true) the function returns the text value A in the
cell where the function is located; If the answer is no (false), then the function tests
the next condition— are the contents of C2 less than or equal to 1000? The process
is repeated until a condition is met. If the last condition, C2<
5000, is not met, a
default value of E terminates the IF , implying that the value in C2 is greater than
5000. Note that the category to be returned is placed in quotes (“A”) to designate
it as text and whatever is placed in the quotes will be returned in the cell as text.
Of course there are many other comparisons, like less than and equal , that can be
made. These include greater than and equal , greater , and equal to , just to name a
few. Additionally, there are numerous logic functions that can be used in conjunc-
tion with IF to perform other logical comparisons: AND , OR , NOT , FA L S E and
TRUE .
Note that our example has violated one of our best spreadsheet Feng Shui
practices—a formula used in numerous locations should not commonly contain
numeric values since a change in values will necessitate a change in every cell
location. It would be wise to create a table area where these numerical values can
be stored and referenced by the IF , and thus, a single change to the table will be
reflected in all cells using the value. Be sure to use an absolute address (e.g. $A$1),
one that has $’s in front of the row and column, if you plan to copy the function to
other locations, otherwise the reference to the table will change and result in errors.
=
Search JabSto ::




Custom Search