Here comes the complex formula
The conditional formula means a formula which can work on conditions specified by the user. In case the condition does not match it will give the result of the second condition
The conditional formula is "IF"
Syntax =if(logical test,[valueif true],[valueiffalse]
Explanation: Logical test is the condition
Value if True means if the condition is satisfied this formula will give the result specified in the formula as true else value if false
Eg: I want to put a formula that if the value of two cells is same then I must get result as "YES" else "NO"...The formula is =IF(C2=B2,"YES","NO")
This If formula is very complex as it can be merged with any excel formula
The three components of this formula can be replaced by any formula
Eg: =IF(COUNT(C2:C10)=4,"YES","NO")
This formula means it first counts the numbers in range C2-C10 and if the result is 4 it gives YES else a NO
Eg: =IF(SUM(C2:C10)=4,"YES","NO")
This formula means it first adds the numbers in range C2-C10 and if the result is 4 it gives YES else a NO
We will learn more on this
2 comments:
this guide of your is excellent for people like me who always wanted to learn formula but did not have access to someone who can teach.
as u might know that most of the computer learning institues too dont teach detail excel...
once again appreciate your effort.
keep it going.
Ketan Kothari
Vinod, you are doing a wonderful job here. Are you taking courses on excel. Please let us know, Thanks.Madan.
Post a Comment