Nested If problem I have 2 worksheets one called data entry and I am trying to d

Question

Nested If problem

I have 2 worksheets one called data entry and I am trying to do a nested if on another sheet using data from that sheet

=IF(AND(ISBLANK('Data entry'!B2),('Data entry'!C2),('Data entry'!D2),('Data entry'!E2),('Data entry'!F2)),'Data entry'!A2,"").

What I want is if all cells from b2 to f2 are blank enter the contents of A2 from data entry sheet otherwise if there is an entry anywhere from b2 to f2 leave Blank. I used the formula above but it only seems to work on the first cell b2. Where am I going wrong please??

Thanks !!

Explanation / Answer

Try

=IF(ISBLANK('Data entry'!B2:F2),A2,"") CTRL+SHIFT+Enter

or for your formula:

=IF(AND(ISBLANK('Data entry'!B2),ISBLANK('Data entry'!C2),ISBLANK('Data entry'!D2),ISBLANK('Data entry'!E2),ISBLANK('Data entry'!F2)),'Data entry'!A2,"")..

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.