#Value! is an Excel warning message that indicates that Excel is unable to calculate a formula. This usually means that one has made an incorrect data entry. Specifically, Excel is expecting a numerical entry and the entry contains some letters, words or symbols in place of, or in addition to, the numbers.
