Nesting IF and IFS formulas

[Atrain21]

I am trying to nest 8 IF formulas and can't figure out how to do it. I have the 8 individual formulas working (see below), but can't combine then in a single cell. I'm using MS Office 2013.


=IF(AJ6="SM STD",'AMZ Fee 2-22-18'!$B$5)
=IF(AJ6="LG STD1",'AMZ Fee 2-22-18'!$B$6)
=IF(AJ6="LG STD2",'AMZ Fee 2-22-18'!$B$7)
=IF(AJ6="LG STD3",(0.38*(AA9-2)+'AMZ Fee 2-22-18'!$B$8)
=IF(AJ6="SM OVER",(0.38*(AA10-2)+'AMZ Fee 2-22-18'!B9)
=IF(AJ6="MED OVER",(0.38*(AA11-2)+'AMZ Fee 2-22-18'!B10)
=IF(AJ6="LG OVER",(0.79*(AA12-90)+'AMZ Fee 2-22-18'!B11)
=IF(AJ6="SPEC OVER",(0.91*(AA13-90)+'AMZ Fee 2-22-18'!B12) THE 'AMZ Fee 2-22-18'! is referring to a cell in another sheet in the workbook.

 

[dreid1011]

Welcome to the board.

Those are working as is? It looks to me like they are missing the FALSE result of the IF statement... and are not closed properly?

Otherwise, I would guess something like this:

=IF(AJ6="SM STD",'AMZ Fee 2-22-18'!$B$5,IF(AJ6="LG STD1",'AMZ Fee 2-22-18'!$B$6,IF(AJ6="LG STD2",'AMZ Fee 2-22-18'!$B$7,IF(AJ6="LG STD3",(0.38*(AA9-2)+'AMZ Fee 2-22-18'!$B$8),IF(AJ6="SM OVER",(0.38*(AA10-2)+'AMZ Fee 2-22-18'!B9),IF(AJ6="MED OVER",(0.38*(AA11-2)+'AMZ Fee 2-22-18'!B10),IF(AJ6="LG OVER",(0.79*(AA12-90)+'AMZ Fee 2-22-18'!B11),IF(AJ6="SPEC OVER",(0.91*(AA13-90)+'AMZ Fee 2-22-18'!B12),""))))))))

Provided this is not more nesting than your version of excel will allow.

 

[Atrain21]

Thanks so much. This worked perfectly. Much appreciated.

 

[dreid1011]

You're welcome.