Need help with formula...

  • Thread starter Thread starter Dan B
  • Start date Start date
D

Dan B

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Need VLOOKUP to Work Two Ways 0
Force unused formula cells to be null 4
Rounding Errors in 2007 14
Help with formula 4
If Function and Vlookups 2
if zero, then return blank/empty 8
Formula than understands midnight? 25

Back
Top