Null values need to be replaced
 

how could I replace the null values by -99.25 for the whole file

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

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

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