| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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))) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I format cells containing a value to display as true/false | Excel Discussion (Misc queries) | |||
| Display TRUE / FALSE Instead Of 1 / 0 | Excel Discussion (Misc queries) | |||
| Display values other than TRUE and FALSE | Excel Discussion (Misc queries) | |||
| Need to supress display of FALSE in a cell | New Users to Excel | |||
| match data in 2 sheets then display true/false from vlkup | Excel Worksheet Functions | |||
Hybrid Mode
