Shorter IF???

[Stu]

Can anyone tell me if I can make this IF statement shorter and simpler
than it is.

=IF(C4<>"","Y",IF(D4<>"","Y",IF(E4<>"","Y",IF(F4<>"","Y",IF(G4<>"","Y",IF(H4<>"","Y",IF(I4<>"","Y",IF(J4<>"","Y","N"))))))))


Thanks
:::::::::
Stu

 

[dvt]

Can anyone tell me if I can make this IF statement shorter and simpler
than it is.

=IF(C4<>"","Y",IF(D4<>"","Y",IF(E4<>"","Y",IF(F4<>"","Y",IF(G4<>"","Y",IF(H4
<>"","Y",IF(I4<>"","Y",IF(J4<>"","Y","N"))))))))

One way:

=IF(SUMPRODUCT(ISBLANK(C4:J4)*1)<8,"Y","N")

Dave
dvt at psu dot edu

 

[klausimausi64]

Hello Stu,

use the following formula, but be careful you have to leave the cell with
ctrl+shift+enter because it's an array formula:

{=IF(AND(ISEMPTY(C4:J4)),"N","Y")}

CU Klaus

 

[Jennifer]

-----Original Message-----
Can anyone tell me if I can make this IF statement shorter and simpler
than it is.

=IF(C4<>"","Y",IF(D4<>"","Y",IF(E4<>"","Y",IF

Thanks
:::::::::
Stu



------------------------------------------------

~~ View and post usenet messages directly from http://www.ExcelForum.com/

.
Here is one way if it is really an OR, as in any one of

those cells can contain a "".
=IF(OR
(C4<>"",D4<>"",E4<>"",F4<>"",G4<>"",H4<>"",I4<>"",J4<>""),"
Y","N")

 

[Dave Peterson]

How about:
=IF(COUNTBLANK(C4:J4)<8,"Y","N")

Can anyone tell me if I can make this IF statement shorter and simpler
than it is.

=IF(C4<>"","Y",IF(D4<>"","Y",IF(E4<>"","Y",IF(F4<>"","Y",IF(G4<>"","Y",IF(H4<>"","Y",IF(I4<>"","Y",IF(J4<>"","Y","N"))))))))

Thanks
:::::::::
Stu

 

[Stefano Gatto]

Being affirmative:

=IF(C4&D4&E4&F4&G4&H4&I4&J4="","N","Y")

Stefano

 

[Ron Rosenfeld]

Can anyone tell me if I can make this IF statement shorter and simpler
than it is.

=IF(C4<>"","Y",IF(D4<>"","Y",IF(E4<>"","Y",IF(F4<>"","Y",IF(G4<>"","Y",IF(H4<>"","Y",IF(I4<>"","Y",IF(J4<>"","Y","N"))))))))


Thanks
:::::::::
Stu

Array-enter:

=IF(OR(D4:J4<>""),"Y","N")

To array-enter, after copying or typing in the formula, hold down <ctrl><shift>
while hitting <enter>. XL will place braces {...} around the formula.


--ron