Spreadsheet: 709893d1608614806-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(G6<101,(10^(+-0.0870109379279779*LOG(G6)^2+-0.334342717266153*LOG(G6)+4.86889558269343)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+3.93574519985476),IF(AND(25001<G6,G6<60000),10^(+-0.031867109701874*LOG(G6)^2+-0.81496016371449*LOG(G6)+6.40990140139958),""))))  &IF(ISNUMBER(SEARCH("Australia",A2)),IF(G6<101,(10^(+-0.0663268860440227*LOG(G6)^2+-0.147552659998071*LOG(G6)+4.92538272190577)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+4.45921846197251),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018787*LOG(G6)^2+-0.814960163714447*LOG(G6)+6.93337466351722),""))))  &IF(ISNUMBER(SEARCH("Armenia",A2)),IF(G6<101,(10^(+-0.0740383408362915*LOG(G6)^2+-0.0880449778876935*LOG(G6)+4.62897639139295)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.21156446862459*LOG(G6)+4.24947762689261),IF(AND(25001<G6,G6<60000),10^(+-0.031867109701885*LOG(G6)^2+-0.81496016371439*LOG(G6)+6.72363382843719),""))))  &IF(ISNUMBER(SEARCH("Denmark",A2)),IF(G6<101,(10^(-0.042802328*LOG(G6)^2-0.289877956*LOG(G6)+4.875861487)),IF(AND(100<G6,G6<25002),10^(-0.153860293*LOG(G6)^2+0.285157748*LOG(G6)+4.131715003),IF(AND(25001<G6,G6<60000),10^(0.187919421*LOG(G6)^2+-2.948711532*LOG(G6)+11.73573633),""))))  &IF(ISNUMBER(SEARCH("Barbados",A2)),IF(G6<101,(10^(+-0.0549033193294823*LOG(G6)^2+-0.178091641232748*LOG(G6)+5.01421620592086)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.21156446862459*LOG(G6)+4.53780519118272),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018832*LOG(G6)^2+-0.814960163714406*LOG(G6)+7.01196139272735),""))))  &IF(ISNUMBER(SEARCH("Belarus",A2)),IF(G6<101,(10^(+-0.0730721841504075*LOG(G6)^2+-0.282754081364449*LOG(G6)+4.83325340073879)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+4.06512310099281),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018681*LOG(G6)^2+-0.814960163714544*LOG(G6)+6.53927930253775),""))))  &IF(ISNUMBER(SEARCH("Argentina",A2)),IF(G6<101,(10^(+-0.0606790636884384*LOG(G6)^2+-0.279463559178621*LOG(G6)+5.18607223596894)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550556*LOG(G6)^2+0.211564468624588*LOG(G6)+4.47725605635425),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018777*LOG(G6)^2+-0.814960163714456*LOG(G6)+6.95141225789898),""))))  &IF(ISNUMBER(SEARCH("Bavaria",A2)),IF(G6<101,(10^(+-0.0736296153318224*LOG(G6)^2+-0.395457106521411*LOG(G6)+4.56598632405945)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624588*LOG(G6)+3.56378403356858),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018728*LOG(G6)^2+-0.[PHONE]*LOG(G6)+6.03794023511342),""))))  &IF(ISNUMBER(SEARCH("Andorra",A2)),IF(G6<101,(10^(+-0.0643936190269603*LOG(G6)^2+-0.299699495240258*LOG(G6)+5.11330031343958)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550556*LOG(G6)^2+0.211564468624588*LOG(G6)+4.34734953283408),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018677*LOG(G6)^2+-0.814960163714548*LOG(G6)+11.73573633),""))))  &IF(ISNUMBER(SEARCH("Bangladesh",A2)),IF(G6<101,(10^(+-0.0738055861259681*LOG(G6)^2+-0.20817826578536*LOG(G6)+4.93618709308057)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.21156446862459*LOG(G6)+4.31793500754846),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018787*LOG(G6)^2+-0.814960163714447*LOG(G6)+6.79209120909317),""))))  &IF(ISNUMBER(SEARCH("Austran Empire",A2)),IF(G6<101,(10^(+-0.0611484320865668*LOG(G6)^2+-0.215461860752114*LOG(G6)+4.[PHONE])),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+4.07674371351695),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018782*LOG(G6)^2+-0.814960163714452*LOG(G6)+6.55089991506167),""))))  &IF(ISNUMBER(SEARCH("Bolivia",A2)),IF(G6<101,(10^(+-0.0767958129378459*LOG(G6)^2+0.073744011693055*LOG(G6)+3.00336881422746)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550556*LOG(G6)^2+0.211564468624588*LOG(G6)+2.94360594806281),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018738*LOG(G6)^2+-0.814960163714491*LOG(G6)+5.41776214960762),""))))  &IF(ISNUMBER(SEARCH("Benin",A2)),IF(G6<101,(10^(+-0.0252197258667546*LOG(G6)^2+-0.146608192373818*LOG(G6)+3.74610612641011)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+3.46000988721549),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018818*LOG(G6)^2+-0.814960163714419*LOG(G6)+5.93416608876015),""))))  &IF(ISNUMBER(SEARCH("Angola",A2)),IF(G6<101,(10^(+-0.0617245793461602*LOG(G6)^2+-0.228501640743684*LOG(G6)+4.69082337404034)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+4.08243946049183),IF(AND(25001<[NAME]),""))))  &IF(ISNUMBER(SEARCH("Belize",A2)),IF(G6<101,(10^(+-0.0665829577343141*LOG(G6)^2+-0.151379336806432*LOG(G6)+5.25789401458283)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+4.78675209947954),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018799*LOG(G6)^2+-0.814960163714436*LOG(G6)+7.26090830102423),""))))  &IF(ISNUMBER(SEARCH("Baden",A2)),IF(G6<101,(10^(+-0.0642959661221419*LOG(G6)^2+-0.170053717069814*LOG(G6)+5.02350392712832)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.21156446862459*LOG(G6)+4.52369693727136),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018814*LOG(G6)^2+-0.814960163714422*LOG(G6)+6.99785313881602),""))))  &IF(ISNUMBER(SEARCH("Austria",A2)),IF(G6<101,(10^(+-0.0801213883089445*LOG(G6)^2+-0.392246479959614*LOG(G6)+3.55830357182029)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+2.54954359445397),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018747*LOG(G6)^2+-0.814960163714484*LOG(G6)+5.02369979599877),""))))  &IF(ISNUMBER(SEARCH("Bosnia",A2)),IF(G6<101,(10^(+-0.0822374782509521*LOG(G6)^2+-0.287300753652665*LOG(G6)+4.52177421749299)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+3.70589079531389),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018729*LOG(G6)^2+-0.[PHONE]*LOG(G6)+6.18004699685873),""))))  &IF(ISNUMBER(SEARCH("Bahamas",A2)),IF(G6<101,(10^(+-0.0116396835897657*LOG(G6)^2+-0.098644154500972*LOG(G6)+3.17556112886582)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+3.04555019333401),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018779*LOG(G6)^2+-0.814960163714455*LOG(G6)+5.51970639487874),""))))  &IF(ISNUMBER(SEARCH("Azerbaijan",A2)),IF(G6<101,(10^(+-0.0443272129154265*LOG(G6)^2+-0.409890704381691*LOG(G6)+4.96808194197777)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+4.06068393646306),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018777*LOG(G6)^2+-0.814960163714458*LOG(G6)+6.53484013800781),""))))  &IF(ISNUMBER(SEARCH("Brono",A2)),IF(G6<101,(10^(+-0.08972020687023*LOG(G6)^2+-0.153571720679787*LOG(G6)+4.92837129380083)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.21156446862459*LOG(G6)+4.35421297741262),IF(AND(25001<[NAME]),""))))  &IF(ISNUMBER(SEARCH("Brunei",A2)),IF(G6<101,(10^(+-0.0260578148548816*LOG(G6)^2+-0.148886225405821*LOG(G6)+3.[PHONE])),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+3.62006032405004),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018773*LOG(G6)^2+-0.81496016371446*LOG(G6)+6.09421652559478),""))))  &IF(ISNUMBER(SEARCH("Antigua and Barbuda",A2)),IF(G6<101,(10^(+-0.0615533708158519*LOG(G6)^2+-0.210029541587344*LOG(G6)+4.96115588358401)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.21156446862459*LOG(G6)+4.39118110235872),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018767*LOG(G6)^2+-0.814960163714465*LOG(G6)+6.86533730390348),""))))  &IF(ISNUMBER(SEARCH("Belgium",A2)),IF(G6<101,(10^(+-0.0591163611077769*LOG(G6)^2+-0.0671578133753349*LOG(G6)+4.52229541049416)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.21156446862459*LOG(G6)+4.25521728508449),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018876*LOG(G6)^2+-0.814960163714366*LOG(G6)+6.72937348662903),""))))  &IF(ISNUMBER(SEARCH("Albania",A2)),IF(G6<101,(10^(-0.053268957*LOG(G6)^2+-0.177760803*LOG(G6)+5.072320038)),IF(AND(100<G6,G6<25002),10^(-0.124610453*LOG(G6)^2+0.163946511*LOG(G6)+4.655371961),IF(AND(25001<G6,G6<60000),10^(-0.272717828*LOG(G6)^2+1.450661092*LOG(G6)+1.856105705),""))))  &IF(ISNUMBER(SEARCH("Bahrain",A2)),IF(G6<101,(10^(+-0.0835810912568161*LOG(G6)^2+-0.499168411073315*LOG(G6)+4.40795392591015)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+3.15160358578193),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018667*LOG(G6)^2+-0.814960163714558*LOG(G6)+5.[PHONE]),""))))  &IF(ISNUMBER(SEARCH("Algeria",A2)),IF(G6<101,(10^(+-0.0647544943756403*LOG(G6)^2+-0.384408946649154*LOG(G6)+5.14641198512806)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550556*LOG(G6)^2+0.211564468624587*LOG(G6)+4.20489549423987),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018767*LOG(G6)^2+-0.814960163714465*LOG(G6)+11.73573633),""))))  &IF(ISNUMBER(SEARCH("Botswana",A2)),IF(G6<101,(10^(+-0.226118408453661*LOG(G6)^2+-0.15212621769621*LOG(G6)+3.69882199590996)),IF(AND(100<G6,G6<25002),10^(+-0.137103000550557*LOG(G6)^2+0.211564468624589*LOG(G6)+2.54954359445397),IF(AND(25001<G6,G6<60000),10^(+-0.0318671097018747*LOG(G6)^2+-0.814960163714484*LOG(G6)+5.02369979599877),""))))
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