|
FALSE logic function
|
|
In IT binary Word FALSE returns zero value- Excel work the same. Remember zero value is not the same as no value. For example zero value from FALSE cell in A1 (example below) is not the same as empty cell, cause empty cell has no logic value for some Excel function as AVERAGEA at the example. FALSE logic function Exercises1. Type different logic values: TRUE and FALSE in range of cells A1:A10 and use =AVERAGEA(A1:A10). 2. Work at the database from exercise 1 use =AVERAGEA(A5:B5). How does Excel count when there are logic values and empty cells, maybe he doesn’t count empty cells?  Check all Beginner's Tips Learn how to use Excel functions and formulas in three steps of difficulty >> |
| Stats |