Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to use 'IF function' in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 268

PostPosted: Sun Dec 25, 2016 9:41 pm    Post subject: How to use 'IF function' in Excel Reply with quote

What is IF function in Excel?

IF function

- is a logical function

- that checks the condition you put and returns you one value if the condition is TRUE, else the other value if the condition is FALSE


So the syntax for IF function is:


=IF(condition, value_if_true, value_if_false)


It simply says, if the condition is met, then take the value given for value_if_true, but if the condition is not met, then take the value given for value_if_false. That's it.



Let's check this easy table: Students Grade





So here you have a table with students name and grades. In Column C you want to show the results who passed the exam and who failed. In cell C2 enter the if statement

=IF(B2<=45;"Failed";"Passed")

It says, if the student grade is equal to or less than 45, then put Failed in cell C2, otherwise put Passed.

Now copy the formula down the Column C.



However, if you would like to show the results only when a student is passed, and for the failed ones you want to keep the cells blank, then type the following in cell C2:

=IF(B2<=45;"";"Passed")

Copy it down the Column C.

To show the cells blank use double quotation marks ("") without space in-between.





So this is your first lesson with the if function Smile



*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.

For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group