Hi Excel is unable to do a simple AVERAGE calculation with values that come from a text truncation.
- C19 is calculated as =LEFT(C18,1)
- C24 is calculated as =LEFT(C23,1)
- C29 is calculated as =LEFT(C28,1)
- Quality Avg (C30) is calculated as
The error checking shows that each value in the AND function is the correct number. But Excel is unable to calculate the average and returns a #DIV/0!. How can a division by 3 return that error? This is in Excel 2013.
Also, why do the blank columns return #DIV/0!? The IF statement checks for blanks.