How to use TRUE function in Microsoft Excel

Follow by Email

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 [email protected]


Please follow and like us:

Leave a Reply

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

To avoid automated spam,Please enter the value *

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>