When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

The #NULL error occurs when you use an incorrect range operator in a formula or when you use an intersection operator between range references. Here's the fix!