to show value = 0 if cell bank

[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

 

[lidaroz]

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" пишет:

 

[Gary''s Student]

=IF(J5="",0,VLOOKUP(J5,'C:\System\[member.xls]member'!$O$2:$P$10064,2,FALSE))

 

[ramzi]

hi lidaroz n Gary,

Thanks for your help. it works..


bye

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