TRUE & FALSE ALWAYS IN UPPER CASE

Hi friends hope you like this Post. I want to tell you something interesting topic for MS Excel.

As all of we know that if we want to write any word in Capital (Upper Case) in Excel or anywhere else we will ON Caps Lock and OFF to write in Lower Case. But. do you know there are two words which are exception. Those two words are such, that can’t be written in Lower Case. Yes, you can’t write those in Lower case.

Those two words are,
1) TRUE

2) FALSE

Yes, these words are such that can’t be written in Lower case. After keep Caps Lock OFF
if you type these words it will be automatically written in uppercase.

Reason:

If you are using Formulas and all then you can understand this reason very well. While we are using the formula especially in conditional formulas, like “IF” formula.

Example which is given below will help you out to understand this reason of “TRUE_FALSE ALWAYS IN UPPER CASE” easily.

Example

     TRUE_FALSE ALWAYS IN UPPER CASE Pic.1

According to this conditional formula if the Cell value of A1 is written as “PRATIK” you will get “YES” output in B1 but if not then you will get “NO”. This is what you know very well. Now According to this formula if condition is fulfilled it means “TRUE” otherwise its “FALSE”. These are the default words which are defined for formulas and conditions in MS Excel for technical result.

See in the below picture,

     TRUE_FALSE ALWAYS IN UPPER CASE Pic.2

From above example we understood how condition is giving the output correctly. But same scenario is in the 2^nd Example where in A2=8. According to formula output should be “YES” though its giving “NO”, but why. Formula is written same as above Example just value changed then why its giving the wrong output though its correct.

The reason is the value in A2 is numeric and formula which we used in above case was for alphabet (words). See in the 3^rd Pic.

     TRUE_FALSE ALWAYS IN UPPER CASE Pic.3

When value is Numeric we can’t use “”(comma) to define them. The point is that the difference between numeric and alphabetical values is to use of “”(comma) with them. So, in the 3 Pic., we can see that if we are not using comma the formula is giving the right output.

If I come to the main point of TRUE_FALSE they are not defined as words that’s why while creating a formula we can use them without comma also. As all of we know that there is nothing like Upper case or Lower case for Numeric values. So, we can also say that in Excel definition these words TRUE & FALSE are numeric values.

There is nothing like Upper Case and Lower Case  for numeric values. So the reason for TRUE & FALSE always in Upper case is they are defined ass numeric.

Solution:

If there is requirement to write them in Lower Case then just chill yes you can. Use formula “=LOWER(cell address)”. This will help you out to write them in Lower Case.

May this topic you like in next post we will talk about other interested stuff.

Thanks

 

Please give me your valuable Feedback by your comments...

Kind Regards,
Pratik Dave