| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to show value = 0 if cell bank
hi there,
i have formula as below.... =VLOOKUP(J5,'C:\System\[member.xls]member'!$O$2:$P$10064,2,FALSE) if J5 is blank, it will show some number... how i going to ensure the value is 0 if J5 is blank. rgds |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to show value = 0 if cell bank
hello,
If I understood you correctly, you can use formula: =if(J5="",0,VLOOKUP(J5,'C:\System\[member.xls]member'!$O$2:$P$10064,2,FALSE)) The result of this formula will be 0 if J5 is blank "ramzi" пишет: hi there, i have formula as below.... =VLOOKUP(J5,'C:\System\[member.xls]member'!$O$2:$P$10064,2,FALSE) if J5 is blank, it will show some number... how i going to ensure the value is 0 if J5 is blank. rgds |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to show value = 0 if cell bank
hi lidaroz n Gary,
Thanks for your help. it works.. :) bye "lidaroz" wrote: hello, If I understood you correctly, you can use formula: =if(J5="",0,VLOOKUP(J5,'C:\System\[member.xls]member'!$O$2:$P$10064,2,FALSE)) The result of this formula will be 0 if J5 is blank "ramzi" пишет: hi there, i have formula as below.... =VLOOKUP(J5,'C:\System\[member.xls]member'!$O$2:$P$10064,2,FALSE) if J5 is blank, it will show some number... how i going to ensure the value is 0 if J5 is blank. rgds |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to show value = 0 if cell bank
=IF(J5="",0,VLOOKUP(J5,'C:\System\[member.xls]member'!$O$2:$P$10064,2,FALSE))
-- Gary''s Student - gsnu200829 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is a bank stock? | Excel Discussion (Misc queries) | |||
| Bank Links | Excel Discussion (Misc queries) | |||
| Bank Reconciliation | Excel Discussion (Misc queries) | |||
| Bank interest | Excel Discussion (Misc queries) | |||
| Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel | |||
Hybrid Mode
