How do I display a 0 instead of FALSE
 

My cell g2 may have nothing in it at times. But I need the formula cell to
display a 0 if cell g2 is blank. My formula is below. HELP!!!


=IF('Sales Forcast'!G2='Sales Forcast'!$AV$2,VLOOKUP('Sales
Forcast'!H2,'Sales Forcast'!$AL$2:$AN$9,3,IF('Sales Forcast'!G2=" ",0)))

How do I display a 0 instead of FALSE
 

Bud wrote:
My cell g2 may have nothing in it at times. But I need the formula cell to
display a 0 if cell g2 is blank. My formula is below. HELP!!!


=IF('Sales Forcast'!G2='Sales Forcast'!$AV$2,VLOOKUP('Sales
Forcast'!H2,'Sales Forcast'!$AL$2:$AN$9,3,IF('Sales Forcast'!G2=" ",0)))

I'd check your parentheses. Are you sure you don't mean to say:

=IF('Sales Forcast'!G2='Sales Forcast'!$AV$2,VLOOKUP('Sales
Forcast'!H2,'Sales Forcast'!$AL$2:$AN$9,3), IF('Sales Forcast'!G2="
",0))

or
=IF('Sales Forcast'!G2='Sales Forcast'!$AV$2,VLOOKUP('Sales
Forcast'!H2,'Sales Forcast'!$AL$2:$AN$9,3),0)

---
HTH,

Isaac

How do I display a 0 instead of FALSE
 

I used your 2nd example and it worked. THANKS!!!

" wrote:


Bud wrote:
My cell g2 may have nothing in it at times. But I need the formula cell to
display a 0 if cell g2 is blank. My formula is below. HELP!!!


=IF('Sales Forcast'!G2='Sales Forcast'!$AV$2,VLOOKUP('Sales
Forcast'!H2,'Sales Forcast'!$AL$2:$AN$9,3,IF('Sales Forcast'!G2=" ",0)))

I'd check your parentheses. Are you sure you don't mean to say:

=IF('Sales Forcast'!G2='Sales Forcast'!$AV$2,VLOOKUP('Sales
Forcast'!H2,'Sales Forcast'!$AL$2:$AN$9,3), IF('Sales Forcast'!G2="
",0))

or
=IF('Sales Forcast'!G2='Sales Forcast'!$AV$2,VLOOKUP('Sales
Forcast'!H2,'Sales Forcast'!$AL$2:$AN$9,3),0)

---
HTH,

Isaac