isnumber(search) based on verbiage found in particular cell

[keridvp1]

I have two formulas that work, but I need to change them to be based on verbiage that is found in a specific cell on the same row. I then want to combine these two formulas so that if the cell is blank then do formula # 1, if the verbiage "Covered" is in the cell then do formula # 2. Here are my two formulas:

Formula # 1: =IF(ISNUMBER(SEARCH("RT",D11)),'2018-2019 Rates'!$G$3,'2018-2019 Rates'!$G$4)

Formula # 2: =IF(ISNUMBER(SEARCH("RT",D12)),'2018-2019 Rates'!$G$3,'2018-2019 Rates'!$G$4)+IF(ISNUMBER(SEARCH("R3",D12)),'2018-2019 Rates'!$G$3,'2018-2019 Rates'!$G$4)

Column AC contains either a blank cell or the word "Covered".

 

[Special-K99]

Does this work?

=IF(ISNUMBER(SEARCH("RT",D12)),'2018-2019 Rates'!$G$3,'2018-2019 Rates'!$G$4)+(AC1="Covered")*IF(ISNUMBER(SEARCH("R3",D12)),'2018-2019 Rates'!$G$3,'2018-2019 Rates'!$G$4)

 

[keridvp1]

@Speciall-K99...thank you this worked perfectly!!