Nested if(isblank) statement

Hi everyone,

Having some difficulty nesting three if(isblank) statements. Here's what I'm trying to do:

if A1 = a value, then A1
if A2 = blank (or #N/A), then A2
if A1 and A2 = blank (or #N/A), then A3

Any ideas?

Thanks guys!!

Try this:

=IF(OR(A1="",ISNA(A1)),IF(OR(A2="",ISNA(A2)),A3,A2),A1)

Hope this helps.

Pete

hi FD and Pete,

Thanks for the reply, guys. Unfortunately neither formula worked. I don't know if it makes a differnces, but A1, A2, and A3 are in different worksheets within the same workbook, and they are all copies of other cells in the same workbook (they contain a simple copy instead of the actual text). Does that make a difference?

Thanks,

Think this might work ...

=IF(A1<>"",A1,IF(OR(ISNA(A2),A2<>""),A2,IF(AND(A1="",A2=""),A3,IF(AND(ISNA(A1),ISNA(A2)),A3))))

Hi Hodpy,

thanks for your suggestions. I'm not getting an error, but I am getting a #N/A result. Any ideas?

Hey guys,

Interestingly enough, each of your formulas work if I have the values as text in the first sheet, but since they are all copies from other sources within the workbook none of the formulas seems to want to read them, i.e, getting #N/A. Any ideas how I can get around this?

Thanks!!

Hey guys,

Looks like I figured it out. It was just a matter of formatting. The formula wouldn't read #N/A cells, so I changed them to show blank if there was an error and it worked. Thanks very much for all your help, everyone.