IF Function
by NDH » Thu Jan 02, 2014 5:08 pm
The "IF" function is a simple and powerful one and helps automate decision making in your spreadsheet. The "IF" function checks if the specified condition is true or false, does one thing if it's true, does another if it's false.
The syntax for IF function is:
=IF(logical_test, [value_if_true], [value_if_false])
For example, let's say we have a spreadsheet of a few students and we need to find out quickly who passed the test. We have their Roll Nos. and Marks in columns B & C respectively. In the 'Status' column (Column D), we can create a simple IF function that will tell us whether or not the student passed. (Let's assume 50 or higher is the passing score).
In cell D4, we would enter =IF(C4>49,"PASS","FAIL"). This tells Excel to look in cell C4 (Marks) and test to see if its greater than 49. If it is, excel enters the word "PASS" in cell D4. If the marks obtained are 49 or lower, the word "FAIL" is entered instead.
Simply drag down the cell with the formula, till the last student and get the Pass / Fail Status of each.
The syntax for IF function is:
=IF(logical_test, [value_if_true], [value_if_false])
For example, let's say we have a spreadsheet of a few students and we need to find out quickly who passed the test. We have their Roll Nos. and Marks in columns B & C respectively. In the 'Status' column (Column D), we can create a simple IF function that will tell us whether or not the student passed. (Let's assume 50 or higher is the passing score).
In cell D4, we would enter =IF(C4>49,"PASS","FAIL"). This tells Excel to look in cell C4 (Marks) and test to see if its greater than 49. If it is, excel enters the word "PASS" in cell D4. If the marks obtained are 49 or lower, the word "FAIL" is entered instead.
Simply drag down the cell with the formula, till the last student and get the Pass / Fail Status of each.
- IF.jpg (44.33 KiB) Viewed 2870 times
- source: Systemfunda.com
--
{{{{ Rawalpindi-Islamabad Friends}}}}
************************************************************************************
All members are expected to follow these Simple Rules
Abuse of any kind (to the Group, or it's Members) shall not be tolerated
SPAM, Advertisement, and Adult messages are NOT allowed
This is not a Love, Dating Forum so sending PM or Chat Inv will be considered as illegal Act. will be BANED Instantly.
************************************************************************************
You received this message because you are subscribed to the Google
Groups "Pindi-Islamabad Friends" group.
To post to this group, send email to Pindi-Islamabad@googlegroups.com
To unsubscribe from this group, send email to
Pindi-Islamabad+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Pindi-Islamabad?hl=en
---
You received this message because you are subscribed to the Google Groups "Pindi-Islamabad Friends" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Pindi-Islamabad+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment