Multi level ifs function

[ohmedic88]

I'm working in Excel 365 and I have a multi level if function that I'm having trouble figuring out.

I'm not sure how to write the formula.

I want to add:
IF G12 is blank and G13 is blank use AA7
IF G12 not blank and G13 is blank use AA8
IF G12 is blank and G13 is not blank use AA8
IF G12 not blank and G13 not blank use AA9

to this formula:
=IF(AND(CopyRME!$AA9="REPORT",CopyRME!$Z9="Within Limits"),CopyRME!$R9,"")

I need Z9 and R9 to change according to the Row # as well. So the first cell ref above would be AA7 Z7 and R7 and so on depending on the G12 and G13 contents.

Much appreciated any help.

ohmedic88
G

 

[Peter_SSs]

You could try these. I think they both do what you want.

=IF(AND(CHOOSE(COUNTBLANK(G12:G13)+1,CopyRME!$AA9,CopyRME!$AA8,CopyRME!$AA7)="REPORT",CHOOSE(COUNTBLANK(G12:G13)+1,CopyRME!$Z9,CopyRME!$Z8,CopyRME!$Z7)="Within Limits"),CHOOSE(COUNTBLANK(G12:G13)+1,CopyRME!$R9,CopyRME!$R8,CopyRME!$R7),"")

=CHOOSE(COUNTBLANK(G12:G13)+1,IF(AND(CopyRME!$AA9="REPORT",CopyRME!$Z9="Within Limits"),CopyRME!$R9,""),IF(AND(CopyRME!$AA8="REPORT",CopyRME!$Z8="Within Limits"),CopyRME!$R8,""),IF(AND(CopyRME!$AA7="REPORT",CopyRME!$Z7="Within Limits"),CopyRME!$R7,""))