| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Null values need to be replaced
how could I replace the null values by -99.25 for the whole file
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Null values need to be replaced
What do you consider as a null value?
The "whole file" means multiple worksheets or? Gord Dibben MS Excel MVP On Tue, 6 Feb 2007 15:57:00 -0800, Hey wrote: how could I replace the null values by -99.25 for the whole file |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Null values need to be replaced
what I mean is blank vlaues. I used IF function and it works for one cell.
I want to replace all blank values in a file by -999.25. Thanks "Gord Dibben" wrote: What do you consider as a null value? The "whole file" means multiple worksheets or? Gord Dibben MS Excel MVP On Tue, 6 Feb 2007 15:57:00 -0800, Hey wrote: how could I replace the null values by -99.25 for the whole file |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Null values need to be replaced
I cannot believe you want to replace all blanks in a file with a value.
Each worksheet has 16,777,216 cells That would make for a very large workbook. Are you saying you have formulas like =IF(A1<15, "",A15) that return "" which is not null but just looks blank? If not, what? Post your IF function formula and is it representative of other formulas? Gord On Tue, 6 Feb 2007 17:14:00 -0800, Hey wrote: what I mean is blank vlaues. I used IF function and it works for one cell. I want to replace all blank values in a file by -999.25. Thanks "Gord Dibben" wrote: What do you consider as a null value? The "whole file" means multiple worksheets or? Gord Dibben MS Excel MVP On Tue, 6 Feb 2007 15:57:00 -0800, Hey wrote: how could I replace the null values by -99.25 for the whole file |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find and replace null values in Excel 2002 worksheets? | Excel Worksheet Functions | |||
| VLookup Null values | Excel Worksheet Functions | |||
| Charting null values | Charts and Charting in Excel | |||
| CSV export from Excel always recognise null values in the last col | Excel Discussion (Misc queries) | |||
| Displaying null values in charts | Charts and Charting in Excel | |||
Hybrid Mode
