Nested if statement that has different criteria with different outcomes

[Meucci98]

Hi there I cannot seem to figure this out for the life of me.

I am getting a Div0 error with the following formula and cannot figure out how to get rid of it.

Does anyone have any ideas?

<tbody>
</tbody>

<colgroup><col span="5"><col></colgroup><tbody>
</tbody>

COLUMN A (TOTAL)	COLUMN B	COLUMN C (COSTS 1)	COLUMN D (COSTS 2)	COLUMN E (COST TO COMPLETE)	COLUMN F
1	AB	1			=IF(B2="BC",(A2+C2)/E2,IF(B2="AB",(A2+D2)/E2,"-"))
2	BC		2

<tbody>
</tbody>

 

[JeanKim]

you are placing 0 value under the fraction. that is why you are getting div 0 error
what is your question?

edit: E2 is blank and blank = 0 in value.

 

[Meucci98]

In column F, I do not want it to return Div0 error even though column E remains empty. Does that help?

 

[JeanKim]

What do you want in column F?
0?
empty cell?
or what?
if you want 0 then =IFERROR(G2/H2,"0")
if you want empty cell then =IFERROR(G2/H2,"")
if you want whatever then =IFERROR(G2/H2,"whatever")

hope that help

 

[Jonmo1]

In column F, I do not want it to return Div0 error even though column E remains empty. Does that help?

Try
=IFERROR(IF(B2="BC",(A2+C2)/E2,IF(B2="AB",(A2+D2)/E2,"-")),"")

 

[Meucci98]

Thanks very much Jonmo1 and JeanKim, this solves my problem.

Cheers

 

[Jonmo1]

You're welcome.