Nested If Formula

Hello all

I've got the following nested if statement that runs 4 different lookups from another worksheet which successfully populates a cell with the value I want.

=IF(AND(G17=1,B3=Detagli!D2),(LOOKUP(H2,agency!C11:C21,agency!O11:O21)),IF(AND(G17=1,B3=Detagli!D3),(LOOKUP(H2,agency!C11:C21,agency!M11:M21)),IF(AND(G17=2,B3=Detagli!D2),(LOOKUP(H2,agency!C35:C51,agency!O35:O51)),IF(AND(G17=2,B3=Detagli!D3),(LOOKUP(H2,agency!C35:C51,agency!M35:M51)),""))))

The above is in Cell C17 in my worksheet and populates C17 with the correct value. For example 6,200.

What I need to do is add 10% to that value, if cell H17 contains the number 9 otherwise just leave as it is.

I've been trying to add the above into another IF statement, but instead of adding 10% (620) to the existing value, just gives me the 10% I need to add.

Thanks

Joe

Probably just add this to the end: *IF(H17=9,1.1,1)

i.e.

Please Login or Register  to view this content.

Hello Joe, try like this

=IF(H17=9,1.1,1)*IF(AND(G17=1,B3=Detagli!D2),LOOKUP(H2,agency!C11:C21,agency!O11:O21),IF(AND(G17=1,B3=Detagli!D3),LOOKUP(H2,agency!C11:C21,agency!M11:M21),IF(AND(G17=2,B3=Detagli!D2),LOOKUP(H2,agency!C35:C51,agency!O35:O51),IF(AND(G17=2,B3=Detagli!D3),LOOKUP(H2,agency!C35:C51,agency!M35:M51)))))