Thread: How do I display a 0 instead of FALSE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bud Bud is offline
external usenet poster
  
Posts: 61
Default 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)))
Reply With QuoteReply With Quote