Posted to microsoft.public.excel.worksheet.functions

Anthony

external usenet poster

Posts: 275

IF(ISBLANK question

Bernie thanks, that works just great

"Bernie Deitrick" wrote:

Anthony,

=IF(Y6="","",IF(COUNTIF(P17:S19,P21)0,"W","L"))

HTH,
Bernie
MS Excel MVP

"Anthony" wrote in message
...
Hi,

I have this formula in cell P23 which almost works...

=IF(COUNTIF(P17:S19,P21)0,"W","L")

can you suggest how to change this to show cell P23 as blank if Y6 is
blank
but if Y6 is populated then carry out the formula?

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 12:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us