#VALUE!

  • Thread starter Thread starter nso
  • Start date Start date
N

nso

i have formula '=G3-G2" in cell g4. when i dont have any info in g3 or g2,
g4 shows #VALUE!. is there somethin i can add to the formula so that if g2
and g3 are blank, g4 will be blank too?
 
Welcome. The =IF(COUNT(G2:G3)<2,"", ... trap simply ensures that G2:G3
contain numbers before proceeding with the arithmetics between them. This
averts the #VALUE error which would result if G2:G3 were to contain text
such as null strings: "", returned by formulas
 

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

How can I reference a cell within a formula 3
regular and overtime hours 1
Over time hours 5
Calc 2
formula setup for number combinations 13
Sumif on columns with logical answers 1
If Formula Help 3
Cell format for an array formula containing text 2

Back
Top