=IF(ISBLANK) Help

[Jules84]

Hi,
I am creating a spreadsheet to collate information from questionnaires. I am wanting the questionnaires to be numbered each time a new one is logged.
I have managed to do this using the following formula =IF(ISBLANK(C4),"",A4+1) only problem is it only works if you starting collating from C4, my first question has a choice of 3 answers to choose from so I need the formula to recognise that information has been logged in C4, D4 and E4 aswell, to allow the next questionnaire number to appear in the line below

I hope this makes sense and someone out there can help me????

 

[Ralajer]

Welcome to the board Jules,

I think I understand what you need but let me know I don't. Use the COUNTA function to counts the number of cells in range that are not blank.

Example
C4=A, D4=3, E4 is blank

=COUTNA(C4:E4)
• Returns 2​

Incorporating that into your if statement.

=IF(COUTNA(C4:E4)<>3,"",A4+1)​

If C4:E4 all contain a value then return A4+1 otherwise return ""

 

[Jules84]

Thank you for your help, I couldnt quiet work out the formula using this way, but I created the following and it has done exactly what I need ~ thanks for your help

=IF(AND(ISBLANK(C4),ISBLANK(D4),ISBLANK(E4)),"",A4+1)