How do I display a 0 instead of FALSE

[Guest]

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

 

[imaycotte]

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)

 

[Guest]

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