Thread: If(ISBLANK)
View Single Post
  #2   Report Post  
Blue Hornet
 
Posts: n/a
Default

Assuming reference blocks (cells) A1, B1, C1:

=IF( ISBLANK( A1), "", IF( AND( ISBLANK( B1), ISBLANK( C1)), "B&C
Blank", IF( ISBLANK( B1), "C1 has an entry!", "B1 has an entry")))