Posted to microsoft.public.excel.misc

ramzi

external usenet poster

Posts: 24

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is a bank stock?	Tamika	Excel Discussion (Misc queries)	2	November 16th 08 07:24 PM
Bank Links	KMH	Excel Discussion (Misc queries)	1	January 3rd 07 02:01 PM
Bank Reconciliation	Tarig	Excel Discussion (Misc queries)	5	December 2nd 06 01:59 PM
Bank interest	April	Excel Discussion (Misc queries)	1	October 24th 06 01:12 AM
Formatting to show/not show "DUE" and "RECEIVED" in cell	kevhatch	New Users to Excel	5	October 9th 05 09:10 PM

All times are GMT +1. The time now is 12:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us