long if function problems

Hi,

When come to long IF function, i always have problems. I have three formulas as below and would like to join them as only one formula under IF function.

=IF(AND($C2=MID(Detail!$B6,5,6),Detail!$K6="ACC"),"129")
=IF(AND($C2=MID(Detail!$B6,5,6),Detail!$K6="HUB"),"130")
=IF(AND($C2=MID(Detail!$B6,5,6),Detail!$K6="BB"),"131")

Could you please kindly advice?

Try:

Please Login or Register  to view this content.