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

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

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

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