|The IF Function is used when a cell can
have one of two values depending on the value of another cell. For
example, a discount can be given IF a purchase is over a certain amount, in
the case below 10% if over $100 but the entire amount is discounted.
In the case where the discount was only on the portion of the
purchases OVER $100,
The IF dialog box has three parameters. They are independent - what you put into one does not affect the others, so sometimes you have to repeat yourself.
Also the following unfortunately some show only the final IF like seen on the top box not the expanded dialog box.
Just be glad your screen does not look like this
Using the IF Statement in Excel 2007 9/2008 4:31
This page was created by Professor
Maureen Greenbaum and was last updated on
Page Name: IF Function Hints
Disclaimer: Information on this site represents the thoughts and opinions expressed by the author and not that of Union County College. The author takes full responsibility for the information presented. By using the information contained herein, the user willingly assumes all risks in connection with such use. Neither the author nor Union County College shall be held liable or responsible for content, errors, and/or omissions in information herein or information contained on any Web Page to which it is linked. Furthermore, neither the author nor Union County College shall be liable for any special, consequential, or exemplary damages resulting, in whole or in part, from any user's use of, or reliance on, this material or material set forth on any Web Page to which it is linked.
Copyright: ã Maureen Greenbaum Sumware in NJ 2001, '02, '03, '04, '05, '06, '07, 08, 09, 10, 11, 12, 13. All rights reserved.