Today I am writing about If or Nested If function in Excel.
If or Nested If function are both same function. Basically these are conditional function , like :-(if this value is 50 then what and if this value is greater or less than 50 then what) so these kind of condition we deals in If or Nested If function.
This function are useful in rating or grading system, same as preparing a marks sheet for the student or doing some grading system of job in the office.
Here are some example
Example No 1.
Here in this example we can see that in column A names are mentioned and in column B the score of the respective name and in column C the result is appearing according to their score like average, good, excellent and so on.
Example No. 2
Here in this example we can see the result in grade system but what is additional in this example that here you can see AND function.
I put another condition in this example like should be B2 >33 but should (less than) B2 <45, similarly B2>45 but (less than) B2<55, so these are the condition I have added in this example. So we can use this two condition also.
Example No. 3
In this example we see that there are two condition Pass or Fail and there is score also. simply we are putting the formula and according to the score the result appearing in column C.
So there are the If o Nested If example.
We can not say that this is the only use of this function but we can use If function in many ways and it depends upon the logic we can apply. We can use this function as many ways and I am sure that we we will use this function in future also because this is a very very useful function.
So goodbye for now
Narendra
If or Nested If function are both same function. Basically these are conditional function , like :-(if this value is 50 then what and if this value is greater or less than 50 then what) so these kind of condition we deals in If or Nested If function.
This function are useful in rating or grading system, same as preparing a marks sheet for the student or doing some grading system of job in the office.
Here are some example
Example No 1.
Here in this example we can see that in column A names are mentioned and in column B the score of the respective name and in column C the result is appearing according to their score like average, good, excellent and so on.
Example No. 2
Here in this example we can see the result in grade system but what is additional in this example that here you can see AND function.
I put another condition in this example like should be B2 >33 but should (less than) B2 <45, similarly B2>45 but (less than) B2<55, so these are the condition I have added in this example. So we can use this two condition also.
Example No. 3
In this example we see that there are two condition Pass or Fail and there is score also. simply we are putting the formula and according to the score the result appearing in column C.
So there are the If o Nested If example.
We can not say that this is the only use of this function but we can use If function in many ways and it depends upon the logic we can apply. We can use this function as many ways and I am sure that we we will use this function in future also because this is a very very useful function.
So goodbye for now
Narendra
No comments:
Post a Comment