How to use multiple isblank statements inside an if statement

Is it possible to use multiple isblank statutes in an if statement. I want to use something like this sudocode

=if(isblank(g8)&isblank(h8), "both blank", "not both blank") =if(isblank(g8&h8), "both blank", "not both blank") 

These functions return a $ VALUE error or return invalid int text in an if statement.

Is there any way to do this?

+6
source share
2 answers
 =if(AND(isblank(g8),isblank(h8)), "both blank", "not both blank") 
+12
source

If your ranges are contiguous, the following formula will take as many arguments as you want, with much stronger syntax when you extend the range:

=if(counta(g8:h8)=0, "both blank", "not both blank")

+2
source

All Articles