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?