data saving as zero

[jalea148]

formula produces non zero result [107k] but saves it as zero. Excel 2010, Win 10.

 

[energman58]

Cant see your formula but my best guess is that the value the formula returns (ie the cell it refers to) is formatted as text and not as a number and the result cell is formatted as a number. In this case the formula may well evaluate to something that looks like a number but it appears in your sheet as text.

HTH

 

[jalea148]

Cant see your formula but my best guess is that the value the formula returns (ie the cell it refers to) is formatted as text and not as a number and the result cell is formatted as a number. In this case the formula may well evaluate to something that looks like a number but it appears in your sheet as text.

HTH

Here's a snippit.

A260 = 1/14/13; the if statement evaluates to 8650.39.

 

[jalea148]

Problem is much easier to demonstrate. If a number is typed into a cell it's OK. However, any function defining the cell results in zero. For example, if B12 is 1234.5 and C12 is = B12 the result in C12 is 0. Note, the file is saved xlsm.

 

[jalea148]

Problem is much easier to demonstrate. If a number is typed into a cell it's OK. However, any function defining the cell results in zero. For example, if B12 is 1234.5 and C12 is = B12 the result in C12 is 0. Note, the file is saved xlsm.

problem solved after iterative calculation OK'd in Options > Formulas