#VALUE!
 

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?

#VALUE!
 

One way, in G4: =IF(COUNT(G2:G3)<2,"",G3-G2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nso" wrote:
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?

#VALUE!
 

One way:

=IF(COUNT(G2:G3)<2,"",G3-G2)

--
Biff
Microsoft Excel MVP


"nso" wrote in message
...
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?

#VALUE!
 

i dont understand it but that worked, thanks!!

"Max" wrote:

One way, in G4: =IF(COUNT(G2:G3)<2,"",G3-G2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nso" wrote:
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?

#VALUE!
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nso" wrote in message
...
i dont understand it but that worked, thanks!!