Previously in a blog post I noted down the key Mathematical Functions of Ms Excel. For whom, it wasn't seen by, read it here.
Logical Functions in Ms Excel will be familiar for those who already learned some programming. But, for them & others syntax of this Ms Excel exampled in here will sure be important as well as worth reading.
Logical Functions will be explained with proper examples as well as images that will be helpful to you.
1. AND - Returns true if all the arguments are true & returns false if any argument is false.
In the above example, A1>=20 & B1=34 & C1<=50 are true. So, as all of the arguments are true the result should be 'TRUE'.
Look at the following example. A1>=20 is the only argument which is true but the result is 'FALSE', as the other two arguments are false. (<> not equal)
2. OR - Returns true if any argument is true & returns false if all arguments are false.
In the above example, A1>20 is the only argument which is true. Both, B1<>(not equal)34,C1<>42 are false. But, the result should be 'TRUE'.
Look at the example below, all the arguments are false here.
The result is false. Having all argument false makes the OR function to return false.
3. NOT - Returns the reverse of the true of false state of an argument. Look at the example below. The A1<>21 is false.
But, ironically it returns true. That's because of the intervention of =NOT() function.
In the following Example A1=21 is true.
Instead of returning the actual state, It returns false.
4. If - returns the value which is set as arguments, when the logical test provided (also as an argument) is true or false.
In the Example, the provided logical test is correct & the function returns "Correct" which is set by us. You can your provide your own value here.
That's it for this Post! Hope You Enjoy Ms Excel Logical Functions.
Logical Functions in Ms Excel will be familiar for those who already learned some programming. But, for them & others syntax of this Ms Excel exampled in here will sure be important as well as worth reading.
Logical Functions will be explained with proper examples as well as images that will be helpful to you.
1. AND - Returns true if all the arguments are true & returns false if any argument is false.
In the above example, A1>=20 & B1=34 & C1<=50 are true. So, as all of the arguments are true the result should be 'TRUE'.
Look at the following example. A1>=20 is the only argument which is true but the result is 'FALSE', as the other two arguments are false. (<> not equal)
2. OR - Returns true if any argument is true & returns false if all arguments are false.
In the above example, A1>20 is the only argument which is true. Both, B1<>(not equal)34,C1<>42 are false. But, the result should be 'TRUE'.
Look at the example below, all the arguments are false here.
The result is false. Having all argument false makes the OR function to return false.
3. NOT - Returns the reverse of the true of false state of an argument. Look at the example below. The A1<>21 is false.
But, ironically it returns true. That's because of the intervention of =NOT() function.
In the following Example A1=21 is true.
Instead of returning the actual state, It returns false.
4. If - returns the value which is set as arguments, when the logical test provided (also as an argument) is true or false.
In the Example, the provided logical test is correct & the function returns "Correct" which is set by us. You can your provide your own value here.
That's it for this Post! Hope You Enjoy Ms Excel Logical Functions.
No comments:
Post a Comment