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

 

[DHayes]

Hi there,
Give this one a try.

=IF(AND(ISBLANK(G12),ISBLANK(G13)),AA7,IF(OR(AND(G12<>"",ISBLANK(G13)),AND(G12<>"",ISBLANK(G13))),AA8,IF(AND(G12<>"",G12<>""),AA9)))

 

[mikerickson]

You could treat booleans as integers.

=CHOOSE(1+(G12="")+(G13=""), $AA$7, $AA$8, $AA$9)

 

[ohmedic88]

I didn't get this one to work properly. The test I ran returned the value in AA9, but I need the value in R8. Maybe I'm confused do I need to add my original formula to your calculation?

 

[ohmedic88]

I haven't yet implemented your solution, but I'm confused. Do I also need to add my formula to part of your calculation.

Eric

 

[mikerickson]

My formula should return this part of the OP

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

Its not clear what you want about R9

 

[ohmedic88]

My formula should return this part of the OP


Its not clear what you want about R9

I am trying to align with a row of data on the CopyRME tab. It is the formula at the bottom of my original comment.

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

So if G12 and G13 is blank I need to align data to AA7 Z7 and R7 values
So if G12 and G13 is not blank I need to align data to AA9 Z9 and R9 values
If 1 is blank and the other is not I need to align data to AA8 Z8 and R8

I'm not sure how to write that code. So it will adjust to the correct result.

Eric

 

[mikerickson]

What does "align data" mean?

 

[ohmedic88]

I need to the Row number to change so it finds the correct data in the correct location of the report that I have.

 

[ohmedic88]

Ok I finaly was able to research the choose formula and I just put my if formula in the aa7, aa8 and aa9. makes for a long formula but I'm gonna try to test it out today.