formula result is zero but zero is not populating in cell
I am working in MS Excel 2003 and am using three worksheets for this
project. The first 2 worksheets contain numerical data and the 3rd worksheet is where I have formulas using values from the other worksheets. When there is a zero value entered on worksheet 1 and the formula on worksheet 3 has a result of zero, the zero value is not populating. I have 'zero values' checked under Options and the cells are formatted 'General'. Does anyone know how I can get the cell with the formula to populate a zero when the formula result equals zero? Thanks in advance for your help. Pat |
formula result is zero but zero is not populating in cell
What happens if you directly type a zero in the cell? Do you see that?
If yes, then it means that your formula is not returning a zero... What does =CODE(A1) return (assuming you have the formula in A1)... if you have zero then it should give you 48. Failing all the above pl. share the formula... and the values in cells it is referring to... " wrote: I am working in MS Excel 2003 and am using three worksheets for this project. The first 2 worksheets contain numerical data and the 3rd worksheet is where I have formulas using values from the other worksheets. When there is a zero value entered on worksheet 1 and the formula on worksheet 3 has a result of zero, the zero value is not populating. I have 'zero values' checked under Options and the cells are formatted 'General'. Does anyone know how I can get the cell with the formula to populate a zero when the formula result equals zero? Thanks in advance for your help. Pat |
formula result is zero but zero is not populating in cell
On Apr 1, 11:40*am, Sheeloo just
remove all As... wrote: What happens if you directly type a zero in the cell? Do you see that? If yes, then it means that your formula is not returning a zero... What does =CODE(A1) return (assuming you have the formula in A1)... if you have zero then it should give you 48. Failing all the above pl. share the formula... and the values in cells it is referring to... " wrote: I am working in MS Excel 2003 and am using three worksheets for this project. The first 2 worksheets contain numerical data and the 3rd worksheet is where I have formulas using values from the other worksheets. When there is a zero value entered on worksheet 1 and the formula on worksheet 3 has a result of zero, the zero value is not populating. I have 'zero values' checked under Options and the cells are formatted 'General'. Does anyone know how I can get the cell with the formula to populate a zero when the formula result equals zero? Thanks in advance for your help. Pat- Hide quoted text - - Show quoted text - When I type a zero directly in the cell I don't see it. Here's the formula: ='PP,DDU & CSS'!H12 H12 is the cell from worksheet 1 and the value of that cell is 0 (zero). The formula is on worksheet 3. |
formula result is zero but zero is not populating in cell
What did you get with
=Code(A1) after replacing A1 with the cell address with the formula... Did you try to enter any other number? Does that show up? Only thing I can think of is that FONT color of that cell is WHITE... Can you upload the file at wikisend.com and paste the link here? Excel version? Should not matter... " wrote: On Apr 1, 11:40 am, Sheeloo just remove all As... wrote: What happens if you directly type a zero in the cell? Do you see that? If yes, then it means that your formula is not returning a zero... What does =CODE(A1) return (assuming you have the formula in A1)... if you have zero then it should give you 48. Failing all the above pl. share the formula... and the values in cells it is referring to... " wrote: I am working in MS Excel 2003 and am using three worksheets for this project. The first 2 worksheets contain numerical data and the 3rd worksheet is where I have formulas using values from the other worksheets. When there is a zero value entered on worksheet 1 and the formula on worksheet 3 has a result of zero, the zero value is not populating. I have 'zero values' checked under Options and the cells are formatted 'General'. Does anyone know how I can get the cell with the formula to populate a zero when the formula result equals zero? Thanks in advance for your help. Pat- Hide quoted text - - Show quoted text - When I type a zero directly in the cell I don't see it. Here's the formula: ='PP,DDU & CSS'!H12 H12 is the cell from worksheet 1 and the value of that cell is 0 (zero). The formula is on worksheet 3. |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com