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

 

[Peter_SSs]

A few comments.

1. Your original formula is a bit hard to follow anyway because it is not a valid formula - there are misplaced & unmatched parentheses at least.
2. When using numerical data, there is no need, and better not to, enclose them in quote marks. So instead of IF(M7<100,"8.84","5.84") just use IF(M7<100,8.84,5.84)
3. You appear to have two identical sections for Budapest in the formula. I can't see why you would have that.

Anyway, see if you could use something like this. In the lookup table in column T onwards
- List the cities down the column
- The green section lists the change-over points, starting at 0 (assuming column M will house positive numbers) for each city.
- The yellow section is the corresponding multiplication value for each of the change-over points for that city.

Then the formula to replace your original long one is shown in A7, and copied down.

Excel Workbook
	A	E	M	P	Q	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1
2						Boston, MA	0	100					8.84	5.84
3						Delhi	0	45	500				6.55	1.5	0.3
4						Budapest	0	100					4.9	3.18
5						Oradea	0	100	250	1000			5.29	4.56	4.31	0.3
6						Guangzhou	0	45	100	250	500	1000	10.97	4.64	3.37	3.06	2.74	2.42
7	402	Boston, MA	50	40
8	560	Oradea	125	10
9	250	Oradea	1100	80
Look up city factor