| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
| Date Entry in 1 Cell with result populating for entire week in ano | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Populating a table with filtered result of another table | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
