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

farazaidi

New Member
Joined
Jun 12, 2018
Messages
4
=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
 

farazaidi

New Member
Joined
Jun 12, 2018
Messages
4
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

New Member
Joined
Aug 17, 2017
Messages
32
=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))))))))))
 

Forum statistics

Threads
1,085,311
Messages
5,382,897
Members
401,808
Latest member
huyennhiteen9xx

Some videos you may like

This Week's Hot Topics

Top