Spreadsheet: 709904d1608621616-combing-multiple-formulas-sample-sheet
Sheet: Sheet1

Country | Value | [NAME] |  | Note:  The formula is pasted in C2 but I can't put equal sign  before formula because formula is very long. I need some work around to keep the formula like this and find different values in more convenient way.
Denmark | 23986 | IF(ISNUMBER(SEARCH("Brazil",A2)),IF(B2<101,(10^(+-0.0870109379279779*LOG(B2)^2+-0.334342717266153*LOG(B2)+4.86889558269343)),IF(AND(100<[NAME]),""))))  &IF(ISNUMBER(SEARCH("Australia",A2)),IF(B2<101,(10^(+-0.0663268860440227*LOG(B2)^2+-0.147552659998071*LOG(B2)+4.92538272190577)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+4.45921846197251),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018787*LOG(B2)^2+-0.814960163714447*LOG(B2)+6.93337466351722),""))))  &IF(ISNUMBER(SEARCH("Armenia",A2)),IF(B2<101,(10^(+-0.0740383408362915*LOG(B2)^2+-0.0880449778876935*LOG(B2)+4.62897639139295)),IF(AND(100<[NAME]<B2,B2<60000),10^(+-0.031867109701885*LOG(B2)^2+-0.81496016371439*LOG(B2)+6.72363382843719),""))))  &IF(ISNUMBER(SEARCH("Denmark",A2)),IF(B2<101,(10^(-0.042802328*LOG(B2)^2-0.289877956*LOG(B2)+4.875861487)),IF(AND(100<B2,B2<25002),10^(-0.153860293*LOG(B2)^2+0.285157748*LOG(B2)+4.131715003),IF(AND(25001<B2,B2<60000),10^(0.187919421*LOG(B2)^2+-2.948711532*LOG(B2)+11.73573633),""))))  &IF(ISNUMBER(SEARCH("Barbados",A2)),IF(B2<101,(10^(+-0.0549033193294823*LOG(B2)^2+-0.178091641232748*LOG(B2)+5.01421620592086)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.21156446862459*LOG(B2)+4.53780519118272),IF(AND(25001<[NAME]),""))))  &IF(ISNUMBER(SEARCH("Belarus",A2)),IF(B2<101,(10^(+-0.0730721841504075*LOG(B2)^2+-0.282754081364449*LOG(B2)+4.83325340073879)),IF(AND(100<[NAME]),""))))  &IF(ISNUMBER(SEARCH("Argentina",A2)),IF(B2<101,(10^(+-0.0606790636884384*LOG(B2)^2+-0.279463559178621*LOG(B2)+5.18607223596894)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550556*LOG(B2)^2+0.211564468624588*LOG(B2)+4.47725605635425),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018777*LOG(B2)^2+-0.814960163714456*LOG(B2)+6.95141225789898),""))))  &IF(ISNUMBER(SEARCH("Bavaria",A2)),IF(B2<101,(10^(+-0.0736296153318224*LOG(B2)^2+-0.395457106521411*LOG(B2)+4.56598632405945)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624588*LOG(B2)+3.56378403356858),IF(AND(25001<[NAME]),""))))  &IF(ISNUMBER(SEARCH("Andorra",A2)),IF(B2<101,(10^(+-0.0643936190269603*LOG(B2)^2+-0.299699495240258*LOG(B2)+5.11330031343958)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550556*LOG(B2)^2+0.211564468624588*LOG(B2)+4.34734953283408),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018677*LOG(B2)^2+-0.814960163714548*LOG(B2)+11.73573633),""))))  &IF(ISNUMBER(SEARCH("Bangladesh",A2)),IF(B2<101,(10^(+-0.0738055861259681*LOG(B2)^2+-0.20817826578536*LOG(B2)+4.93618709308057)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.21156446862459*LOG(B2)+4.31793500754846),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018787*LOG(B2)^2+-0.814960163714447*LOG(B2)+6.79209120909317),""))))  &IF(ISNUMBER(SEARCH("Austran Empire",A2)),IF(B2<101,(10^(+-0.0611484320865668*LOG(B2)^2+-0.215461860752114*LOG(B2)+4.[PHONE])),IF(AND(100<[NAME]<B2,B2<60000),10^(+-0.0318671097018782*LOG(B2)^2+-0.814960163714452*LOG(B2)+6.55089991506167),""))))  &IF(ISNUMBER(SEARCH("Bolivia",A2)),IF(B2<101,(10^(+-0.0767958129378459*LOG(B2)^2+0.073744011693055*LOG(B2)+3.00336881422746)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550556*LOG(B2)^2+0.211564468624588*LOG(B2)+2.94360594806281),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018738*LOG(B2)^2+-0.814960163714491*LOG(B2)+5.41776214960762),""))))  &IF(ISNUMBER(SEARCH("Benin",A2)),IF(B2<101,(10^(+-0.0252197258667546*LOG(B2)^2+-0.146608192373818*LOG(B2)+3.74610612641011)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+3.46000988721549),IF(AND(25001<[NAME]),""))))  &IF(ISNUMBER(SEARCH("Angola",A2)),IF(B2<101,(10^(+-0.0617245793461602*LOG(B2)^2+-0.228501640743684*LOG(B2)+4.69082337404034)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+4.08243946049183),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018802*LOG(B2)^2+-0.814960163714434*LOG(B2)+6.55659566203652),""))))  &IF(ISNUMBER(SEARCH("Belize",A2)),IF(B2<101,(10^(+-0.0665829577343141*LOG(B2)^2+-0.151379336806432*LOG(B2)+5.25789401458283)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+4.78675209947954),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018799*LOG(B2)^2+-0.814960163714436*LOG(B2)+7.26090830102423),""))))  &IF(ISNUMBER(SEARCH("Baden",A2)),IF(B2<101,(10^(+-0.0642959661221419*LOG(B2)^2+-0.170053717069814*LOG(B2)+5.02350392712832)),IF(AND(100<[NAME]<B2,B2<60000),10^(+-0.0318671097018814*LOG(B2)^2+-0.814960163714422*LOG(B2)+6.99785313881602),""))))  &IF(ISNUMBER(SEARCH("Austria",A2)),IF(B2<101,(10^(+-0.0801213883089445*LOG(B2)^2+-0.392246479959614*LOG(B2)+3.55830357182029)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+2.54954359445397),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018747*LOG(B2)^2+-0.814960163714484*LOG(B2)+5.02369979599877),""))))  &IF(ISNUMBER(SEARCH("Bosnia",A2)),IF(B2<101,(10^(+-0.0822374782509521*LOG(B2)^2+-0.287300753652665*LOG(B2)+4.52177421749299)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+3.70589079531389),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018729*LOG(B2)^2+-0.[PHONE]*LOG(B2)+6.18004699685873),""))))  &IF(ISNUMBER(SEARCH("Bahamas",A2)),IF(B2<101,(10^(+-0.0116396835897657*LOG(B2)^2+-0.098644154500972*LOG(B2)+3.17556112886582)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+3.04555019333401),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018779*LOG(B2)^2+-0.814960163714455*LOG(B2)+5.51970639487874),""))))  &IF(ISNUMBER(SEARCH("Azerbaijan",A2)),IF(B2<101,(10^(+-0.0443272129154265*LOG(B2)^2+-0.409890704381691*LOG(B2)+4.96808194197777)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+4.06068393646306),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018777*LOG(B2)^2+-0.814960163714458*LOG(B2)+6.53484013800781),""))))  &IF(ISNUMBER(SEARCH("Brono",A2)),IF(B2<101,(10^(+-0.08972020687023*LOG(B2)^2+-0.153571720679787*LOG(B2)+4.92837129380083)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.21156446862459*LOG(B2)+4.35421297741262),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018803*LOG(B2)^2+-0.814960163714432*LOG(B2)+6.[PHONE]),""))))  &IF(ISNUMBER(SEARCH("Brunei",A2)),IF(B2<101,(10^(+-0.0260578148548816*LOG(B2)^2+-0.148886225405821*LOG(B2)+3.[PHONE])),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+3.62006032405004),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018773*LOG(B2)^2+-0.81496016371446*LOG(B2)+6.09421652559478),""))))  &IF(ISNUMBER(SEARCH("Antigua and Barbuda",A2)),IF(B2<101,(10^(+-0.0615533708158519*LOG(B2)^2+-0.210029541587344*LOG(B2)+4.96115588358401)),IF(AND(100<[NAME]B2,B2<60000),10^(+-0.0318671097018767*LOG(B2)^2+-0.814960163714465*LOG(B2)+6.86533730390348),""))))  &IF(ISNUMBER(SEARCH("Belgium",A2)),IF(B2<101,(10^(+-0.0591163611077769*LOG(B2)^2+-0.0671578133753349*LOG(B2)+4.52229541049416)),IF(AND(100<[NAME]<B2,B2<60000),10^(+-0.0318671097018876*LOG(B2)^2+-0.814960163714366*LOG(B2)+6.72937348662903),""))))  &IF(ISNUMBER(SEARCH("Albania",A2)),IF(B2<101,(10^(-0.053268957*LOG(B2)^2+-0.177760803*LOG(B2)+5.072320038)),IF(AND(100<B2,B2<25002),10^(-0.124610453*LOG(B2)^2+0.163946511*LOG(B2)+4.655371961),IF(AND(25001<[NAME]+1.450661092*LOG(B2)+1.856105705),""))))  &IF(ISNUMBER(SEARCH("Bahrain",A2)),IF(B2<101,(10^(+-0.0835810912568161*LOG(B2)^2+-0.499168411073315*LOG(B2)+4.40795392591015)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550557*LOG(B2)^2+0.211564468624589*LOG(B2)+3.15160358578193),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018667*LOG(B2)^2+-0.814960163714558*LOG(B2)+5.[PHONE]),""))))  &IF(ISNUMBER(SEARCH("Algeria",A2)),IF(B2<101,(10^(+-0.0647544943756403*LOG(B2)^2+-0.384408946649154*LOG(B2)+5.14641198512806)),IF(AND(100<B2,B2<25002),10^(+-0.137103000550556*LOG(B2)^2+0.211564468624587*LOG(B2)+4.20489549423987),IF(AND(25001<B2,B2<60000),10^(+-0.0318671097018767*LOG(B2)^2+-0.814960163714465*LOG(B2)+11.73573633),""))))  &IF(ISNUMBER(SEARCH("Botswana",A2)),IF(B2<101,(10^(+-0.226118408453661*LOG(B2)^2+-0.15212621769621*LOG(B2)+3.69882199590996)),IF(AND(100<[NAME]),""))))
Albania | 5488
Algeria | 47162
Andorra | 55845
Angola | 51249
[NAME] and [NAME] | 55940
Argentina | 31222
Armenia | 32629
Australia | 19387
Austria | 22980
[NAME] | 28863
Azerbaijan | 13154
Brono | 8228
Baden | 15906
Bahamas | 43351
Bahrain | 43553
Bangladesh | 41469
Barbados | 13036
Bavaria | 45933
Belarus | 14420
Belgium | 21442
Belize | 35279
Benin | 32075
Bolivia | 56229
Bosnia | 19443
Botswana | 34737
Brazil | 1116
Brunei | 45049