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.