Combining two working IF Statements into a nested if statement produces #VALUE!

[mramo]

Hello I have two very simple IF statements that work independently of each other and references its results from the same Row.

=IF(A2=B2,"High Quality", "Transcoded")
=IF(A2<320,"Low Quality","High Quality")

When I try to combine them in a nested IF, I receive a #VALUE! error. Is there something I am doing wrong?

I am using Excel 2013.

 

[ChrisFoster]

Try;

=IF(A2=B2,"High Quality",IF(A2<320,"Low Quality","High Quality"))

 

[mramo]

Try;

=IF(A2=B2,"High Quality",IF(A2<320,"Low Quality","High Quality"))

Hi thanks for this.

However the formula is missing the return value of "Transcode" if A2 doesnt equal B2.

=IF(A2=B2,"High Quality", "Transcoded")

 

[ChrisFoster]

Ahh sorry, I missed that. Does this work for you?

=IF(A2=B2,"High Quality",IF(A2<320,"Low Quality","Transcoded"))

 

[mramo]

Ahh sorry, I missed that. Does this work for you?

=IF(A2=B2,"High Quality",IF(A2<320,"Low Quality","Transcoded"))

Fantastic! Thank you so much it worked! Now I know where I went wrong when originally applying the nested IF.

 

[ChrisFoster]

Fantastic! Thank you so much it worked! Now I know where I went wrong when originally applying the nested IF.

You're welcome.

 

[smozgur]

Fantastic! Thank you so much it worked! Now I know where I went wrong when originally applying the nested IF.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.