[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 583: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 632: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 1054: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3813)
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 1054: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3813)
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 1054: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3813)
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 1054: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3813)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5152: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3813)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5152: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3813)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5152: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3813)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5152: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3813)
Excel Tip: IF Function : Microsoft Windows - DevilShouts.com

Excel Tip: IF Function

Breaking News and amazing tweaks about windows stuff from Windows XP to upcoming Windows 9
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1107: count(): Parameter must be an array or an object that implements Countable
saurabhg
Site Admin
Posts: 51
Joined: Sat Jan 04, 2014 10:35 am
Location: India
Contact:

Excel Tip: IF Function

Unread postby saurabhg » Sat Jul 26, 2014 11:24 am

Advertisement

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.

Image

source: Systemfunda.com

Advertisement
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1107: count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1107: count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1107: count(): Parameter must be an array or an object that implements Countable

Return to “Microsoft Windows”

Who is online

Users browsing this forum: No registered users and 0 guests

cron