If Statement

[ktkreeger]

Thanks for the help in advance.

I keep getting an error, and I can't figure out how to fix it. I have a bunch of drop down list that can result in different answers. At the end, I want to take what ever the final answer is and use it to continue on my math equation.

Example 1 Scenario
A1 = #N/A (because I did not choose it in the drop down list)
B1 = #N/A (because I did not choose it in the drop down list)
C1 = 4

D1 = either A1+B2 or C1

So... D1 = 4

Example 2 Scenario
A1 = 12
B1 = 12
C1 = #N/A (because I did not choose it in the drop down list)

D1 = either A1+B2 or C1

So... D1 = 24

Example 3 Scenario
Note for this final example, B1 is not chosen yet I need to add it to A1. I keep getting an error when I do this.

A1 = 2,213
B1 = #N/A (because I did not choose it in the drop down list)
C1 = #N/A (because I did not choose it in the drop down list)

D1 = either A1+B2 or C1

So... D1 = 2,213



Thanks again for the help.

[jeffr27]

Try this:
=IF(OR(IFERROR(A1,0)<>0,IFERROR(B1,0)<>0),IFERROR(A1,0)+IFERROR(B1,0),C1)

[hemesh]

Hello ktkreeger, Can you please upload a sample book?
Thanks

[ktkreeger]

Thanks for the help. When writing this out, I thought of a new way to process the data and was able to come to a solution. I made a really large vlookup with vlookups inside it. I was able to process the data without getting an error.

Thanks for looking and helping.