If(ISBLANK)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to pull from 4 different sheets within the workbook based on whether
1,2, or 3 reference blocks are left blank. If block one is left blank then
the sum should be blank but if it is not blank then the sesult would vary
depending on whether or not one or more of the other blocks were blank or
not. each combination creats different answers. What is the best way to do
this? Thanks.
 
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")))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF(ISBLANK) 4
if(and(isblank( formula help 2
IF ISBLANK Function 5
IF and ISBLANK 4
isblank 4
Whether 3 diff fields are blank determines several different resul 1
Inserting "true" blanks with functions 5
function returning SUM of 2 adjacent cols in 2 separate cells 7

Back
Top