#VALUE!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nso - 16 May 2008 18:36 GMT

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?

Reply to this Message

Max - 16 May 2008 18:41 GMT

One way, in G4: =IF(COUNT(G2:G3)<2,"",G3-G2)

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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?

Reply to this Message

nso - 16 May 2008 18:48 GMT

i dont understand it but that worked, thanks!!

> One way, in G4: =IF(COUNT(G2:G3)<2,"",G3-G2)
> > 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?

Reply to this Message

Max - 17 May 2008 03:25 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>i dont understand it but that worked, thanks!!

Reply to this Message

T. Valko - 16 May 2008 18:43 GMT

One way:

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

Signature

Biff
Microsoft Excel MVP

>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?

Reply to this Message