Updating existing formula to add conditional logic

[bdav1216]

Here is my current formula - everything is working:

=IFERROR(IF(N(R3),IF(O3,O3,P3)-R3,"-"),"-")

I need to add a condition:

If Column Q = "No Do", then perform the calculation else, output '-'.

How would I update this forumula?

 

[smozgur]

You can use AND function, and check two conditions:

=IFERROR(IF(AND(N(R3), Q3="No Do"),IF(O3,O3,P3)-R3,"-"),"-")

 

[bdav1216]

Thank you!

One other question to my existing formula:

=IFERROR(IF(N(R3),IF(O3,O3,P3)-R3,"-"),"-")

How would I adjust this to say :

If Column N GE 1", then perform the calculation else, output '-'.

There are '-' values in Column N if that makes a difference, but I only want to calculate the logic if the value in Column N is GE 1.

How would I update this formula?

 

[smozgur]

Same function, AND, but to check N3 cell value this time:

=IFERROR(IF(AND(N(R3), N3="GE 1"),IF(O3,O3,P3)-R3,"-"),"-")

 

[bdav1216]

To clarify, I didn't mean "GE 1" in the literal sense, but if the value is GE 1.

Also, can I add one final item?

If Column M is GE 1 AND Column N is GE 1, then perform the calculation. Just to note, both are actual values (meaning the data could have 1, 2, 3, or '-') in either column.

 

[smozgur]

Sorry, I didn't understand what GE 1 is.
Perhaps someone else would understand, or you might want to try posting a sample row by using XL2BB.

 

[bdav1216]

Let me try and clarify. Also, thank you!

Current Formula:
=IFERROR(IF(N(R3),IF(O3,O3,P3)-R3,"-"),"-")

Add to existing formula:
If M3 >0 AND N3 > 0 then calculate the formula above OR default to '-'.