Modify 2 formulas, Merge two formulas into one formula

Please, may someone can help me to modify this formulas and merge them into one formula that behave one way or the other as needed depending on the conditions if it's possible.

I have this 1st formula to sum the 2 larges values or sum and deduct half of the 2nd large value if H13=Int. and if H13 is not =Int. then sum the two largest values:

=IF($H$13="Int.",SUM(LARGE($L$18:$L$29,1),LARGE($L$18:$L$29,2)/2),IF($H$13="",SUM(LARGE($L$18:$L$29,1),LARGE($L$18:$L$29,2)),""))

I have this 2nd formula to sum the 2 larges values and if H13=Int. eliminates the 2nd large value and return just the larger value and if H13 is not =Int. then sum the two larges values:

=IF($H$13="Int.",MAX($L$18:$L$29),SUM(LARGE($L$18:$L$29,{1,2})))

What i triyng to do is to make just one formula that behave one way or the other as needed depending on the condition (situation) if R2=Priority and H13=Int. to return the 2nd formula value and if R2 is blank cell (non priority situation) return the first formula value, just want the formula to return the desire value if the int. happen under priority situation or non priority situation (blank cell)

Any help is greatly appreciated, many thanks in advance

Thank you FlameRetired attached the workbook sample, i have the formulas on E14 and E15 and when R2=Priority or a blank cell i been changing to either formula in G14, if you notice there is an * leading the value on G18, this give an interference (Int.) on H13 and O10, one formula (E15)is to use when R2=Priority and the other formula in E14 is to use when R2 is blank, if you remove the * then there is no int. and both formulas sum the 2 largest values, i trying to make just one formula to behave like both, one way or the other depending if R2=Priority or if is a blank cell (Non Pryority).

Hope this explanations helps. Thanks

Originally Posted by FlameRetired

I'm not clear on the details of your question. Can you upload a representative sample Excel workbook.

Thank you FDibbins, is all based on the content in H13 but depend on whatever R2=Priority or a blank cell, seems like you overlook the detail on R2
i have the formulas on E14 and E15 and when R2=Priority or a blank cell i been changing to either formula in G14, if you notice there is an * leading the value on G18, this give an interference (Int.) on H13 and O10, one formula (E15)is to use when R2=Priority and the other formula in E14 is to use when R2 is blank, if you remove the * then there is no int. and both formulas sum the 2 largest values, i trying to make just one formula to behave like both, one way or the other depending if R2=Priority or if is a blank cell (Non Pryority). File attached for reference, thanks.

Originally Posted by FDibbins

=IF($H$13="Int.",SUM(LARGE($L$18:$L$29,1),LARGE($L$18:$L$29,2)/2),IF($H$13="",SUM(LARGE($L$18:$L$29,1),LARGE($L$18:$L$29,2)),""))
=IF($H$13="Int.", MAX($L$18:$L$29),SUM(LARGE($L$18:$L$29,{1,2})))

It looks like no matter what you do, you use teh largest value, so....

=MAX($L$18:$L$29)+ LARGE($L$18:$L$29,2)*IF($H$13="Int.",0.5,1)

However, like FT, I am unclear on how you want to incorporate that 2nd formula? It looks pretty much based on teh same H13 contents?

I'm still not sure I understand but I'll start with this in cell E16:

Formula:

Please Login or Register  to view this content.

The file is attached.

Does this do what you want?

Stoked, way to go FlameRetired, it does what i looking for. Thank you!! for taking the time and help with this. Cheers!!! so stoked.

Originally Posted by FlameRetired

I'm still not sure I understand but I'll start with this in cell E16:

Formula:

Please Login or Register  to view this content.

The file is attached.

Does this do what you want?

So glad it works! Thanks for the rep!