IF Function Hints 




 

 Home
Up
YouTube
VLOOKUP Function Hints
IF Function Hints
Cell Names & Reference
IF & Naming Quiz
PMT Function Hints
References
In the News
Cyber-Briefcase
Learning Pyramid
Photos of Students
CIS100 Comp. Apps
The Internet - CIS120
Web Page Development
Tips and Tricks
Job Search
Spring '08  Schedule
Tutorial Sites
Hints for Printing
About M.L.G.
Disclaimer


 

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.

A

B

Price

$70

Discount =IF(B1>100,B1*10%,0)
You Pay =B1-B2

In the case where the discount was only on the portion of the purchases OVER $100,
it would look like this:

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.

University of South Dakota has a tutorial on IF

Also the following unfortunately some show only the final IF like seen on the top box not the expanded dialog box.

bullet TechRepublic Tech Republic show dialog boxes and simple IF
bulletExcel 2002 by the ESL Computer Book has 3 pages that go step by step with many screen shot
bullet Linda's Computer Stop Home Page Linda's Computer Shop
bullet Title: Jan's Illustrated Computer Literacy 101 Jan discusses both If and naming calls

Do the IF& Naming Quiz

Just be glad your screen does not look like this

Home ] Up ] YouTube ] VLOOKUP Function Hints ] [ IF Function Hints ] Cell Names & Reference ] IF & Naming Quiz ] PMT Function Hints ]
References ] In the News ] Cyber-Briefcase ] Learning Pyramid ] Photos of Students ] CIS100 Comp. Apps ] The Internet - CIS120 ] Web Page Development ] Tips and Tricks ] Job Search ] Spring '08  Schedule ] Tutorial Sites ] Hints for Printing ] About M.L.G. ] Disclaimer ]

This page was created by Professor Maureen Greenbaum and was last updated on 04/04/06 .

Page Name:  IF Function Hints
URL:            
http://faculty.ucc.edu/business-greenbaum/C100SS_HIF.htm

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, 2008.  All rights reserved. AddThis Social Bookmark Button