In Excel TRUE is a value that returns 1, but it’s not the same as 1. Some of Excel’s function count logic values and others ‘see’ them as text. For example you can use AVERAGEA on TRUE and FALSE values but simple AVERAGE can’t count them.



In the example above we see that AVERAGEA counts TRUE as 1. We have only two logic function TRUE and FALSE.

TRUE logic function Exercises