Multiplying Two Cells Returns Zero
I created a formula field that multiplies two cells and it returns 0
even if the numbers in those cells are greater than 0.
The formula is
=K2*J2
The values I see in those cells are:
K2 = 16.32
J2 = 380
Any help would be appreciated
Solution 1:
Also check to see if you are creating a circular calculation. If Excel is already warning you of a circular calculation in another part of your spreadsheet, it won't directly warn you if you create another circular calculation. It may just give you a 0 result instead.
Solution 2:
I was experiencing this too and the problem was that I was referring to the wrong cell. When you merge cells, a single cell can consist of multiple rows or columns. Make sure to use the far left column or the top row when you reference a merged cell.