Wednesday, December 21, 2011

Where To Start To Learn MS Excel Logical Functions?

   There are 6 Logical Functions in MS Excel. 'IF' is the commonly and widely used Logical Function among all.

We mostly use remaining 5 logical functions along with the other functions combinely or shelden independently.

The following are the Logical Functions in MS Excel
  • TRUE
  • AND
  • OR
  • NOT
  • IF
  • IFERROR (*you can find in 2007 version of MS Excel)
In MS Excel language, Logic is nothing but a Question.

Generally, few questions has straight answers
  • What Is Your Name?  Saran/Harsha/....

Some questions has only TWO ANSWERS either YES or NO
  • Is 10 greaterthan 11?  NO
  • Is 25 equals to 5*5?   YES

In excel language, YES is nothing but the TRUE and NO is nothing but the FALSE.

TRUE and FALSE are nothing but the logical results.

  • Is 10 equal to 100?
  • Is 45+24 not qual to 99?
  • Is 18/2 is equal to 9?

If your answers for the above logics are FALSE, TRUE and TRUE, means you are in track.

One point I forget to mention earlier that MS Excel understands the Formula only when we use "Is Equal To" (=) symbol before the Formula.

If you forget to put equal symbol, Excel will display the Formula as Regular Text.

Since we gained some knowledge about excel language, let me reframe the question in different way.

Coming to the same exercise now.
  • =(10=100)
  • =((45+24)<>99)
  • =(18/2=9)
Note: Greter than (>), Less than (<), Equal to (=), Not Equal to (<>/><), Multiply (*), Divided by (/), Plus (+), Minus (-)

You should have get the same results ie.FALSE, TRUE and TRUE

Now, you can open your excel and copy paste the above logics, and then check for the results.

Congratulations !! You successfully executed your first function in excel.

I will explain, How To Use "IF Function" in MS Excel in the next lession.

If you have any questions, please comment below and I can respond you at the earliest.

1 comment:

  1. This comment has been removed by a blog administrator.


Share your comment here..