IS(BLANK) - ExcelBanter

Posted to microsoft.public.excel.programming

Jim

external usenet poster

Posts: 615

IS(BLANK)

Can I use this function and apply it to a range of cells. I am trying to use
the following formula;

=IF(OR(ISBLANK(F18),(F19),(F20),(F21),(F22),(F23), (F24),(F25),(F26),(F27),(F28),(F29)),L47,"")

It works if I have a number in cell (F18), but when there is no number in
cell (F18), but one in cell (F19) it doesn't work.

Can anyone help. Or, is there a better way.

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
Index/match - make blank cells return a blank value.	diaare	Excel Worksheet Functions	3	May 3rd 23 03:44 AM
Excel 2002: Return blank when VLOOKUP on blank cells	Mr. Low	Excel Discussion (Misc queries)	2	June 4th 09 05:12 PM
Average Formula to display blank cell if named range is blank	Rachael F	Excel Worksheet Functions	3	February 22nd 08 05:05 PM
Not showing blank and non blank items in filter mode for values	Bhaskar Polisetty	Excel Worksheet Functions	0	June 20th 06 02:04 PM
Copying and pasting a worksheet to a blank and removing blank rows	Bob Reynolds[_3_]	Excel Programming	0	June 24th 04 02:55 PM

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

Menu

About Us