The specified formula cannot be entered because it uses more levels of nesting than allowed in the current file format

[farazaidi]

=IF(E7="Bostan,MA",IF(M7<100,"8.84","5.84")*M7-P7,IF(E7="Delhi",IF(M7<45,"6.55",IF(M7<500,"1.50","0.30")*M7-P7),IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Oradea",IF(M7<100,"5.29",IF(M7<250,"4.56",IF(M7<1000,"4.31","0.30")*M7-P7,IF(E7="Guangzhou",IF(M7<45,"10.97", IF(M7<100,"4.64",IF(M7<250,"3.37",IF(M7<500,"3.06",IF(M7<1000,"2.74","2.42")*M7-p7))))))))))))

how to solve if

 

[SteveO59L]

think I would be inclined to tabulate the relationships and use vlookup()

 

[Kamal GKJ]

Can i have the file

 

[Kamal GKJ]

I guess u have closed all the arguments till delhi.

 

[Peter_SSs]

Can i have the file

All information should remain available to all members of the forum. Refer to #4 of the Forum Rules

 

[farazaidi]

I don't know use vlookup for condition formula

 

[farazaidi]

I already try for this..and it success

=IF(E7="Bostan,MA",IF(M7<100,"8.84","5.84")*M7-P7,IF(E7="Delhi",IF(M7<45,"6.55",IF(M7<500,"1.50","0.30")*M7-P7),IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Oradea",IF(M7<100,"5.29",IF(M7<250,"4.56",IF(M7<1000,"4.31","0.30")*M7-P7

 

[Kamal GKJ]

All information should remain available to all members of the forum. Refer to #4 of the Forum Rules

Sorry For that

 

[Kamal GKJ]

=IF(E7="Bostan,MA",IF(M7<100,"8.84","5.84")*M7-P7,IF(E7="Delhi",IF(M7<45,"6.55",IF(M7<500,"1.50","0.30")*M7-P7),IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Oradea",IF(M7<100,"5.29",IF(M7<250,"4.56",IF(M7<1000,"4.31","0.30")*M7-P7,IF(E7="Guangzhou",IF(M7<45,"10.97", IF(M7<100,"4.64",IF(M7<250,"3.37",IF(M7<500,"3.06",IF(M7<1000,"2.74","2.42")*M7-p7))))))))))))

how to solve if

I think You can try this formula.
=IF(E7="Bostan,MA",IF(M7<100,"8.84","5.84")*M7-P7,IF(E7="Delhi",IF(M7<45,"6.55",IF(M7<500,"1.50","0.30")*M7-P7),IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Oradea",IF(M7<100,"5.29",IF(M7<250,"4.56",IF(M7<1000,"4.31","0.30")*M7-P7)),IF(E7="Guangzhou",IF(M7<45,"10.97",IF(M7<100,"4.64",IF(M7<250,"3.37",IF(M7<500,"3.06",IF(M7<1000,"2.74","2.42")*M7-P7))))))))))

 

[farazaidi]

still same error