Using an If statement in Microsoft Excel
Published on 27 February 14
Bharath
0
Ever wondered the C Programming conditional statement "IF" can be used in Excel, Yes it can be used in the same syntax.
The syntax:
= IF(Enter Condition, What to display if the condition is true, What to display if the condition is false)
The syntax:
= IF(Enter Condition, What to display if the condition is true, What to display if the condition is false)
Example: You have two columns with the person and their age, you have to find out the count of people with age less than 30.
if(B2<30,1,0)
Condition: B2<30 ( since the requirement is less than 30, if it less than or equal to use <=30)
Condition passes : 1 (it displays 1)
Condition Fails: 0 (it displays 0)
Condition: B2<30 ( since the requirement is less than 30, if it less than or equal to use <=30)
Condition passes : 1 (it displays 1)
Condition Fails: 0 (it displays 0)
Sum of the result value in Column C is the final count which you are looking for.
The formula can come handy when you have hundreds of thousands of records.
Note: The calculation is much faster than the generic SUMIF() function.
The formula can come handy when you have hundreds of thousands of records.
Note: The calculation is much faster than the generic SUMIF() function.
This blog is listed under
Development & Implementations
and Data & Information Management
Community
Related Posts:
Post a Comment
