ISBLANK function for multiple cells?

[copleyr]

Hello,

I am currently using the function:

=IF(OR(ISBLANK(C8), ISBLANK (D8), ISBLANK (E8), ISBLANK (F8), ISBLANK (G8), ISBLANK (H8), ISBLANK (I8), ISBLANK (J8), ISBLANK (K8), ISBLANK (L8), ISBLANK (M8), ISBLANK (N8), ISBLANK (O8), ISBLANK (P8), ISBLANK (Q8), ISBLANK (R8)), "", IF(SUM(C8:R8)=0,"Yes", "No"))

and it is returning a #value error sign.

I want it to check if C8:R8 is blank, and if so, put nothing. But if not, use the formula: IF(SUM(C8:R8)=0,"Yes", "No"))

Any suggestions?

Thanks in advance for your help.

 

[IKC]

Use this formula

=IF(and(ISBLANK(C8:R8)),"",IF(SUM(C8:R8)=0,"Yes", "No"))

and hit Ctrl + Shift + Enter.


Hope this one will work fine.

Regards,
Aasim

I realize this discussion was a quite a long time ago, but I had reason to look at it recently and concluded that Aasim's use of the AND function (as opposed to use of the OR function) was the correct way to go to accomplish what I understand to be copleyr's intent--i.e. that blank is produced by the subject formula if and only if all cells in C8:R8 are blank and either "Yes" or "No" is produced by the subject formula if any cells in C8:R8 are not blank (even if some, but not all, cells in C8:R8 are blank). Presumably, C8:R8 contains nothing and/or arguments appropriate for summing by the SUM formula component of the subject formula).

 

[ricodlalli]

Hey copleyr,
Not sure if you ever got this question answered. Try this:
=IF(OR(ISBLANK(C8:R8)),"",((IF(SUM(C8:R8)=0,"",(SUM(C8:R8))))))
If the range C8:R8 is blank, has a zero or has text then the cell with this formula is blank. Otherwise, you will get the sum of the numbers in the range C8:R8.
Hope that helps.