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 =IF(NOT(AND(ISBLANK(C19),ISBLANK(C24),ISBLANK(C29))),AVERAGE(C19,C24,C29),') 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? Mac computers 2017. This is in Excel 2013.

• Value Error In Excel

Also, why do the blank columns return #DIV/0!? The IF statement checks for blanks.

Value Error In Excel

Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel Web App Excel for iPhone Excel for Android tablets Excel for Android phones Excel for Windows Phone 10 Excel Mobile Excel Starter 2010 More. Excel 2013—A simple prompt will appear informing you that you created a circular reference, giving you the option to choose OK or Cancel. If you click OK, the formula appears in the cell but might display zero, as shown in Figure 1. Numbers for mac tutorial.