Merge Excel Formula

[JoeRooney]

Hi,

I am having difficulties merging two formulas together , I keep getting an error when adding it and am unsure how to solve.

=IF(AND(RIGHT(C7)="B",G7="Mobility",COUNTIFS(C:C,LEFT(C7,LEN(C7)-1)&"*")>1),VLOOKUP(@A:A,'Mobility - Product table V.1'!A:N,7,0)-VLOOKUP(@A:A,'Mobility - Product table V.1'!A:X,17,0))

Into

=IF(G7="Direct",VLOOKUP(@A:A,'Product Table - Direct V.1'!A:M,6,0),IF(AND(G7="Mobility PPI",H7="Core"),M7*4.38%-IF(AND(G7="Mobility PPI",H7="Core"),M7*4.38%)*N7/100,IF(AND(G7="Mobility PPI",H7="Senior"),M7*10.73%-IF(AND(G7="Mobility PPI",H7="Senior"),M7*10.73%)*N7/100,IF(AND(G7="Direct PPI",H7="Core"),M7*4.2%,IF(AND(G7="Direct PPI",H7="Senior"),M7*10.3%,IF(AND(H7="Safe Plus",L7=24),M7*3.92%-IF(AND(H7="Safe Plus",L7=24),M7*3.92%)*N7/100,IF(AND(H7="Safe Plus",L7=36),M7*4.91%-IF(AND(H7="Safe Plus",L7=36),M7*4.91%)*N7/100,IF(AND(H7="Safe Plus",L7=48),M7*7.25%-IF(AND(H7="Safe Plus",L7=48),M7*7.25%)*N7/100,IF(AND(H7="Safe Plus",L7=60),M7*10.11%-IF(AND(H7="Safe Plus",L7=60),M7*10.11%)*N7/100)))))))))

Is it possible to have the top formula included in the second formula?

Thanks

 

[JoeRooney]

Correction:

I need to merge

=IF(AND(RIGHT(C2)="B",G2="Mobility",COUNTIFS(C:C,LEFT(C2,LEN(C2)-1)&"*")>1),VLOOKUP(@A:A,'Mobility - Product table V.1'!A:N,7,0)-VLOOKUP(@A:A,'Mobility - Product table V.1'!A:X,17,0),VLOOKUP(@A:A,'Mobility - Product table V.1'!A:N,7,0)

+

IF(G2="Direct",VLOOKUP(@A:A,'Product Table - Direct V.1'!A:M,6,0),IF(AND(G2="Mobility PPI",H2="Core"),M2*4.38%,IF(AND(G2="Mobility PPI",H2="Senior"),M2*10.73%,IF(AND(G2="Direct PPI",H2="Core"),M2*4.2%,IF(AND(G2="Direct PPI",H2="Senior"),M2*10.3%,IF(AND(H2="Safe Plus",L2=24),M2*3.92%,IF(AND(H2="Safe Plus",L2=36),M2*4.91%,IF(AND(H2="Safe Plus",L2=48),M2*7.25%,IF(AND(H2="Safe Plus",L2=60),M2*10.11%))))))))))

Into one formula

 

[Sufiyan97]

Not Tested just merged please try and let us know if it works

=IF(G2="Direct",VLOOKUP(@A:A,'Product Table - Direct V.1'!A:M,6,0),IF(AND(G2="Mobility PPI",H2="Core"),M2*4.38%,IF(AND(G2="Mobility PPI",H2="Senior"),M2*10.73%,IF(AND(G2="Direct PPI",H2="Core"),M2*4.2%,IF(AND(G2="Direct PPI",H2="Senior"),M2*10.3%,IF(AND(H2="Safe Plus",L2=24),M2*3.92%,IF(AND(H2="Safe Plus",L2=36),M2*4.91%,IF(AND(H2="Safe Plus",L2=48),M2*7.25%,IF(AND(H2="Safe Plus",L2=60),M2*10.11%,IF(AND(RIGHT(C2)="B",G2="Mobility",COUNTIFS(C:C,LEFT(C2,LEN(C2)-1)&"*")>1),VLOOKUP(@A:A,'Mobility - Product table V.1'!A:N,7,0)-VLOOKUP(@A:A,'Mobility - Product table V.1'!A:X,17,0),VLOOKUP(@A:A,'Mobility - Product table V.1'!A:N,7,0)))))))))))

 

[JoeRooney]

Perfect Thank you

 

[Sufiyan97]

You're Welcome!