Posted to microsoft.public.excel.worksheet.functions

strawberry strawberry is offline

external usenet poster

Posts: 4

Misunderstanding isblank

If all the cells within the given range are blank, the following
formula evaluates to "#VALUE!"

=IF(AND(ISBLANK(H42:CS42)),"",CHAR(MAXA(Sheet1!32: 32)))

I'd be grateful if someone can tell me either how to correctly rewrite
the formula or, failing that, how to supress the error. The error
doesn't affect overalll performance. It's just rather unsightly.

Any help greatly appreciated.

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()	alex	Excel Worksheet Functions	6	February 8th 07 10:33 PM
ISBLANK	Gimpy815	Excel Worksheet Functions	2	February 24th 06 06:09 PM
IF(ISBLANK)	Bill R	Excel Worksheet Functions	4	August 13th 05 07:43 PM
If(ISBLANK)	Bill R	Excel Worksheet Functions	1	August 13th 05 05:56 PM
ISBLANK	Aaron Neunz	Excel Worksheet Functions	3	November 12th 04 05:40 PM

All times are GMT +1. The time now is 04:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us