Hi,
I have a list of numbers in column G. Some of the cells are NULL. Column H
multiplies these numbers by 1000. I then copied and pasted values over the
original formula. Where there is a NULL in column G, I of course got a
#VALUE! in column H. I now want to replace the #VALUE! with the original
NULL. I know I can do a find and replace, but my question is how have the
formula pull the null over to column H. Here is my formula so far:

=if(G16="null", G16,

If I end the formula there with a ) I get a FALSE where there is not a null.
I want it to ignore everything unless its null.

Hope that makes sense.

thx

How about...
=if(G16="", G16, G16 * 1000)
- John


Dan B wrote:
Hi,
I have a list of numbers in column G. Some of the cells are NULL. Column H
multiplies these numbers by 1000. I then copied and pasted values over the
original formula. Where there is a NULL in column G, I of course got a
#VALUE! in column H. I now want to replace the #VALUE! with the original
NULL. I know I can do a find and replace, but my question is how have the
formula pull the null over to column H. Here is my formula so far:

=if(G16="null", G16,

If I end the formula there with a ) I get a FALSE where there is not a null.
I want it to ignore everything unless its null.

Hope that makes sense.

thx

hi,

on H column use

=if(iserror(g2*1000),"null",g2*1000)

hth
regards from Brazil
Marcelo

"Dan B" escreveu:

Hi,
I have a list of numbers in column G. Some of the cells are NULL. Column H
multiplies these numbers by 1000. I then copied and pasted values over the
original formula. Where there is a NULL in column G, I of course got a
#VALUE! in column H. I now want to replace the #VALUE! with the original
NULL. I know I can do a find and replace, but my question is how have the
formula pull the null over to column H. Here is my formula so far:

=if(G16="null", G16,

If I end the formula there with a ) I get a FALSE where there is not a null.
I want it to ignore everything unless its null.

Hope that makes sense.

thx

It looks like both of those answers will work.

Thanks for your help.


"Marcelo" wrote in message
...
hi,

on H column use

=if(iserror(g2*1000),"null",g2*1000)

hth
regards from Brazil
Marcelo

"Dan B" escreveu:

Hi,
I have a list of numbers in column G. Some of the cells are NULL.
Column H
multiplies these numbers by 1000. I then copied and pasted values over
the
original formula. Where there is a NULL in column G, I of course got a
#VALUE! in column H. I now want to replace the #VALUE! with the original
NULL. I know I can do a find and replace, but my question is how have
the
formula pull the null over to column H. Here is my formula so far:

=if(G16="null", G16,

If I end the formula there with a ) I get a FALSE where there is not a
null.
I want it to ignore everything unless its null.

Hope that makes sense.

thx