Problem in combining two formula (If , And, OR)

[Syed Kashif]

Hi, I am Syed Kashif new here please i need your helping

I am finding difficulty to combine both formula in one cell (F4 and F15)

Formula in F4 IF(OR(C4="L",C4="C",C4="R"),IF(B4="OP",E4-D4,F3+E4-D4),"")

Formula in F15 IF(OR(C15="A",C15="E"),IF(B15="op",E15-D15,F14-E15+D15),"")

 

[snjpverma]

Untested:

=IFERROR(IF(OR(C4="L",C4="C",C4="R"),IF(B4="OP",E4-D4,F3+E4-D4),""), IF(OR(C15="A",C15="E"),IF(B15="op",E15-D15,F14-E15+D15),""))

 

[Syed Kashif]

Untested:

=IFERROR(IF(OR(C4="L",C4="C",C4="R"),IF(B4="OP",E4-D4,F3+E4-D4),""), IF(OR(C15="A",C15="E"),IF(B15="op",E15-D15,F14-E15+D15),""))

 

[Syed Kashif]

not working
I have attach an excel in the above post

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: finding problem in combining to functions (If, And, Or)
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Syed Kashif]

This is my first day here and I don't know much about the rules. I Will be careful in future.

 

[Syed Kashif]

=IF(OR(C4="L",C4="C",C4="R"),IF(B4="OP",E4-D4,F3+E4-D4),IF(OR(C4="A",C4="E"),IF(B4="op",D4-E4,F3-E4+D4),""))
I Got my answer
thanks to every for taking part in Help others
Syed Kashif

 

[Syed Kashif]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: finding problem in combining to functions (If, And, Or)
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

=IF(OR(C4="L",C4="C",C4="R"),IF(B4="OP",E4-D4,F3+E4-D4),IF(OR(C4="A",C4="E"),IF(B4="op",D4-E4,F3-E4+D4),"")) this is Right Solution
I found A solution to my question and as I an New here, I don't how to Mark it "Solved" anyways the tick next your answer. I am clicking it.