Range of cells are blank, return a blank or continue with formula

[nickpavlov]

Hello,

How can I check if a range of cells are blank?

For example, if any cells are blank in a range of A1:E1 then return a blank, all cells must contain a value to continue with the formula.

Thank for any help.

Nick

[nickpavlov]

This works, but is there a shorter way to do?

=IF(OR(A1="",B1="",C1="",D1="",E1=""),""

Thanks,

[wk9128]

Hi
This is yours formula

Please Login or Register  to view this content.

Pls try

Please Login or Register  to view this content.

[nickpavlov]

Thanks wk9128, what are the benefits to writing it out that way? Since it is not shorter. Thanks!

[wk9128]

Short, does this count? TRUE means the formula is established

Please Login or Register  to view this content.

[nickpavlov]

Thank you wk9128!

[wk9128]

@nickpavlov You're Welcome. Glad to help . Thank You for the feedback and rep.