# Multiple if isna

1. ## Multiple if isna

Hi,

I want to write the following formula and I get part of it then lose another and am getting nowhere fast. Could someone help please?

I have 2 columns of figures in Column AF and AH.

There could be #N/A in column AF or AH or both.

I want to put a sum in column AK2 which is along these lines (I'll write it as I would speak it)

If the contents of both AF2 and AH2 = #N/A Then AK2 0

That covers where boths columns have #N/A

If the contents of AF2 = #N/A Then AK2 = AH2

That covers where just column AF has #N/A

If the contents of AH2 = #N/A Then AK2 = AF2

That covers where just column AH has #N/A

Many thanks for any help.

2. ## Re: Multiple if isna

If the contents of both AF2 and AH2 = #N/A Then AK2 0
That covers where boths columns have #N/A
If the contents of AF2 = #N/A Then AK2 = AH2
That covers where just column AF has #N/A
If the contents of AH2 = #N/A Then AK2 = AF2
That covers where just column AH has #N/A

Formula:
`Please Login or Register  to view this content.`

Regards, TMS

3. ## Re: Multiple if isna

Hello

Perhaps

Formula:
`Please Login or Register  to view this content.`

4. ## Re: Multiple if isna

Hi
=IF(AND(ISERROR(AF2),ISERROR(AH2)),0,IF(ISERROR(AF2),AH2,AF2))

5. ## Re: Multiple if isna

Thanks Guys,

All your solutions work but I realise I have made one error they only work if there is a #N/A in the one or both cells. Can you suggest a solution?
There are three scenarios below - I need to pick up the 4 in Scenarios 1 and 2 and return a 0 for Scenario 3.Sorry for missing this.

Scenario 1
Column AF2 = 4
Column AH2 = #N/A

Scenario2
Column AF2 = #N/A
Column AH2 = 2

Scenario3
Column AF2 = #N/A
Column AH2 = #N/A

6. ## Re: Multiple if isna

Thanks Guys,

All your solutions work but I realise I have made one error they only work if there is a #N/A in the one or both cells. Can you suggest a solution?
There are three scenarios below - I need to pick up the 4 in Scenarios 1 and 2 and return a 0 for Scenario 3.Sorry for missing this.

Scenario 1
Column AF2 = 4
Column AH2 = #N/A

Scenario2
Column AF2 = #N/A
Column AH2 = 2

Scenario3
Column AF2 = #N/A
Column AH2 = #N/A

7. ## Re: Multiple if isna

Post #2 allows for this ... "what now"

If neither are #N/A, put the result in there.

Regards, TMS

8. ## Re: Multiple if isna

=SUMIF(AF1,"<>#n/a")+SUMIF(AH1,"<>#n/a")

Thanks TMS.

10. ## Re: Multiple if isna

You're welcome. Thanks for the rep.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1