Re: Determine Cell Value Based On Multiple Criteria In Two Columns

Hi AAE,

That is perfect! Thank you very much. I updated the formula because I did not want the calculation to take place if the Instrument Types were anything other than the six instrument types that I had listed. I was able to handle that though since you nicely broke out the formulas into separate cells in your attachment. Really appreciate you doing that for me, I learned a lot looking that over. It now looks like this:

=IF(AND(A9<>"ABS",A9<>"CMP",A9<>"CMV",A9<>"CRF",A9<>"CRP",A9<>"CRZ"),H9,IF(AND(OR(A9="ABS",A9="CMP",A9="CMV",A9="CRF",A9="CRP",A9="CRZ"),AND(OR(LEFT(B9,1)="A",LEFT(B9,3)="BBB",LEFT(B9,3)="Baa"),OR(NOT(ISERR(FIND("A",B9))),NOT(ISERR(FIND("BBB",B9))),NOT(ISERR(FIND("Baa",B9))))),AND(OR(LEFT(C9,1)="A",LEFT(C9,3)="BBB",LEFT(C9,3)="Baa"),OR(NOT(ISERR(FIND("A",C9))),NOT(ISERR(FIND("BBB",C9)))))),H9,0.15))

I've tested the formula on my real spreadsheet and it looks to be doing exactly what I want. Please be assured that your efforts and time on this is most appreciated. You saved me a ton of stress. Great job!

Regards,

JL