Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google SheetsYou type =A2+B2, and instead of a total the cell shows #VALUE!. Hover it and the tooltip says: Function ADD parameter 2 expects number values. But 'pcs' is a text and cannot be coerced to a number. 11H20h ago · 3 min readsheeterror.hashnode.dev