Posted to microsoft.public.excel.misc

Dave

external usenet poster

Posts: 1,388

Error with ISBLANK function

Hi,

I'm trying to achieve the following:

In Cell A49 I want to have a value from D49. But if D49 is blank, I want the
value from C49, but if C49 is blank I want the value from B49.

=IF(ISBLANK(D49),((ISBLANK(C49),(B49),(C49),)),D49 )

is what I have come up with but it doesn't seem to be correct. Can someone
please show me where I've gone wrong.

Thanks!
Dave

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
ISBLANK FUNCTION	Bill R	Excel Worksheet Functions	7	April 30th 07 06:57 PM
ISBLANK function???	Zilla[_2_]	Excel Worksheet Functions	3	February 22nd 07 07:42 PM
ISBLANK() function	George	New Users to Excel	1	July 14th 06 08:40 AM
error message ISBLANK	Hans	Excel Discussion (Misc queries)	4	January 12th 05 03:49 PM
isblank function	Brian	Excel Worksheet Functions	8	December 12th 04 01:35 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us