How to use TRUE function in Microsoft Excel

In this article, we will learn how to use TRUE function in Microsoft Excel.

In Excel, TRUE function helps to return a logical value of TRUE.

image 1


We can directly type the word TRUE onto the worksheet or as function without taking any argument in it.

Let’s take an example to understand:-

  • In cell A8, we’ll type TRUE function
  • Then hit tab to autocomplete the function and as we can see that this function does not take any argument, we close the parentheses and hit enter
  • Function returns the Boolean value TRUE

image 2


We can avoid typing the parentheses if we want the function to return TRUE. So as soon as we complete the name of the function, we can hit enter and then also the function returns TRUE.

image 3


We hope you have learnt how to use TRUE function in Microsoft Excel.


image 48


Video: How to use TRUE function in Microsoft Excel

Click on the video link for quick reference to the use of TRUE function. Subscribe to our new channel and keep learning with us!


If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube