Forum Discussion
Ryan_Foster
Feb 09, 2023Copper Contributor
Need help with product formula showing up wrong answers
Hello, I am having issues with having my spreadsheet auto multiply numbers to build a running total. i have attached a screenshot. If anyone could help sooner rather than later that would be great as...
Riny_van_Eekelen
Feb 10, 2023Platinum Contributor
Ryan_Foster I suspect that both columns B and C contain texts that look like numbers. Multiplying two texts with the PRODUCT function results in zero. You need to fix that first. Format both columns as Number and select the entire column B. On the Data ribbon, select Text-to-columns and directly press Finish. Don't change anything else. Repeat for column C. Now, the texts have become numbers and the formula shall work.
By the way, no need to use PRODUCT. You can just use =B2*C2 and it would have triggered a VALUE error to indicate something is wrong with the underlying "numbers". As said, PRODUCT just returns zero as it ignores texts.