EXCEL常用函数实例

EXCEL常用函数实例1ABS实例绝对值2AND实例参数的逻辑值为真时，返回TRUE；只要一个参数的逻辑值为假，即返回FALSE3AVERAGE实例算术平均值4COLUMN实例引用的列标5CONCATENATE实例合并文本字符串。6COUNTIF实例满足给定条件的单元格的个数7DATE实例日期8DATEDIF实例计算不同间隔条件下的时间差,如计算剩余期限9DAY实例日期中的日数10DCOUNT实例含数字的单元格个数11FREQUENCY实例12IF实例执行真假值判断13INDEX实例列表或数组中的元素值14INDIRECT实例返回由文本字符串指定的引用。返回与引用单元格名称相同工作表指定单元格的数值15INT实例向下舍入取整16ISERROR实例检验数值或引用类型的九个工作表函数17LEFT实例本字符串中的前几个字符18LEN实例文本字符串中的字符数19MATCH实例指定数值匹配的数组中元素的相应位置20MAX实例最大值21MIN实例最小值22MOD实例两数相除的余数23MONTH实例日期中的月份24NOW实例当前日期和时间25OR实例参数逻辑值26RANK实例数字列表中的排位27RIGHT实例文本字符串中最后一个或多个字符28ROUND实例取整函数29SIGN实例返回数字的符号。当数字为正数时返回1，为零时返回0，为负数时返回-1。30SUBTOTAL实例分类汇总31SUM实例数字之和32SUMIF实例条件求和33SUMPRODUCT实例几组数组中，将数组间对应的元素相乘，并返回乘积之和。条件求和公式。34TEXT实例将数值转换为按指定数字格式表示的文本35TODAY实例当前日期的序列号36VALUE实例文本字符串转换成数字37VLOOKUP实例在表格或数值数组的首列查找指定的数值，并由此返回表格或数组当前行中指定列处的数值38WEEKDAY实例返回某日期为星期几39404142431、ABS85-100100回目录782、AND897080true回目录#VALUE!#NAME?653、AVERAGE123a4503.75算术平均值回目录2.5654、COLUMN6082回目录535、CONCATENATE56mascxfmascitymascxf@mascity.com回目录mascxf@mascity.com6、COUNTIF4回目录7、DATE2/4/04回目录9、DAY1/31/1218回目录3112、IF符合要求回目录14、INT-19回目录15、ISERROR123false回目录416、LEFT我喜欢天极网我喜欢回目录17、LEN我今年28岁6回目录106019、MAX10回目录1atrue45620、MID我喜欢天极网天极网回目录21、MIN1回目录22、1回目录123、MONTH1/31/1212回目录220032/5/09200924、NOW1"月"31"日"回目录6:01PM25、OR7059true回目录#VALUE!#NAME?26、我喜欢天极网天极网回目录我喜欢天极网31、TEXT1280.45$1280.45回目录32、TODAY40939.0回目录33、VALUE12345123123回目录12312335、WEEKDAY2回目录341学号姓名性别语文语文语文10401丁1男85.0>=70<8010402丁2男71.010403丁3女71.0510404丁4女70.010405丁5男75.010、DCOUNT回目录10406丁6男72.010407丁7男92.02615610408丁8男68.010409丁9女67.013、INDEX回目录10410丁10女62.013151526156姓名语文体育丁185A丁290A丁398B丁497B丁586C丁682C丁776D丁884A丁989A丁1092B丁1198B丁1297B丁1387C丁1483C丁1584C丁1685D丁1785D丁1884D丁1982E丁2086E丁2190B丁2298B丁2393C丁2478C丁2576C丁2674D丁2772E丁2880B丁2980B丁3087C分数区间0-5905960-6906970-7957980-89168990-100910011、FREQUENCY回目录学号姓名性别语文10401丁1男85.0丁8810402丁2男71.010403丁3女71.018、MATCH10404丁4女70.010405丁5男75.0回目录10406丁6男72.010407丁7男92.010408丁8男68.010409丁9女67.010410丁10女62.0姓名语文名次名次1丁185151426、RANK14丁290822回目录22丁39812828丁49742626丁586131717丁6822288丁7762733丁884181111丁989102121丁109272424丁119812828丁129742626丁1387111919丁1483211010丁1584181111丁1685151414丁1785151414丁1884181111丁19822288丁2086131717丁219082222丁229812828丁239362525丁24782655丁25762733丁26742922丁27723011丁28802466丁29802466丁3087111919学号姓名性别语文10401丁1男67.010402丁2男71.010403丁3女71.010404丁4女70.010405丁5男75.010406丁6男72.010407丁7男64.010408丁8男68.010409丁9女79.010410丁10女77.010411丁11男75.010412丁12男69.010413丁13男74.010414丁14女88.010415丁15男68.010416丁16女81.010417丁17女80.010418丁18女75.010419丁19男71.010420丁20女66.010421丁21女79.010422丁22男73.010423丁23女69.010424丁24男85.010425丁25女82.010426丁26男81.010427丁27男70.010428丁28男77.010429丁29男78.010430丁30男83.010431丁31男77.010432丁32男77.010433丁33女78.010434丁34男77.010435丁35男81.010436丁36女82.010437丁37男75.010438丁38男69.010439丁39女79.010440丁40女75.010441丁41男77.010442丁42女56.010443丁43女62.010444丁44男83.010445丁45男71.010446丁46男74.010447丁47女83.010448丁48男52.010449丁49男73.010450丁50男64.010451丁51女76.010452丁52女79.010453丁53男74.010454丁54女85.010455丁55男67.010456丁56女72.010457丁57女73.010458丁58女70.010459丁59男72.010460丁60女82.010461丁61女75.010462丁62女76.0626228、SUBTOTAL回目录学号姓名性别语文10401丁1男67.010402丁2男71.010403丁3女71.010404丁4女70.010405丁5男75.010406丁6男72.010407丁7男64.010408丁8男68.010409丁9女79.010410丁10女77.010411丁11男75.010412丁12男69.010413丁13男74.010414丁14女88.010415丁15男68.010416丁16女81.010417丁17女80.010418丁18女75.010419丁19男71.010420丁20女66.010421丁21女79.010422丁22男73.010423丁23女69.010424丁24男85.010425丁25女82.010426丁26男81.010427丁27男70.010428丁28男77.010429丁29男78.010430丁30男83.010431丁31男77.010432丁32男77.010433丁33女78.010434丁34男77.010435丁35男81.010436丁36女82.010437丁37男75.010438丁38男69.010439丁39女79.010440丁40女75.010441丁41男77.010442丁42女56.010443丁43女62.010444丁44男83.010445丁45男71.010446丁46男74.010447丁47女83.010448丁48男52.010449丁49男73.010450丁50男64.010451丁51女76.010452丁52女79.010453丁53男74.010454丁54女85.010455丁55男67.010456丁56女72.010457丁57女73.010458丁58女70.010459丁59男72.010460丁60女82.010461丁61女72.010462丁62女76.0总分4601.029、SUM回目录总分1424学号姓名性别语文10401丁1男67.010402丁2男71.010403丁3女71.010404丁4女70.010405丁5男75.010406丁6男72.010407丁7男64.010408丁8男68.010409丁9女79.010410丁10女77.010411丁11男75.010412丁12男69.010413丁13男74.010414丁14女88.010415丁15男68.010416丁16女81.010417丁17女80.010418丁18女75.010419丁19男71.010420丁20女66.010421丁21女79.010422丁22男73.010423丁23女69.010424丁24男85.010425丁25女82.010426丁26男81.010427丁27男70.010428丁28男77.010429丁29男78.010430丁30男83.010431丁31男77.010432丁32男77.010433丁33女78.010434丁34男77.010435丁35男81.010436丁36女82.010437丁37男75.010438丁38男69.010439丁39女79.010440丁40女75.010441丁41男77.010442丁42女56.010443丁43女62.010444丁44男83.010445丁45男71.010446丁46男74.010447丁47女83.010448丁48男52.010449丁49男73.010450丁50男64.010451丁51女76.010452丁52女79.010453丁53男74.010454丁54女85.010455丁55男67.010456丁56女72.010457丁57女73.010458丁58女70.010459丁59男72.010460丁60女82.010461丁61女72.010462丁62女76.0男生总分2484.030、SUMIF回目录女生总分2117学号姓名性别语文10401丁1男67.010402丁2男71.010403丁3女71.010404丁4女70.010405丁5男75.010406丁6男72.010407丁7男64.010408丁8男68.010409丁9女79.010410丁10女77.010411丁11男75.010412丁12男69.010413丁13男74.010414丁14女88.010415丁15男68.010416丁16女81.010417丁17女80.010418丁18女75.010419丁19男71.010420丁20女66.010421丁21女79.010422丁22男73.010423丁23女69.010424丁24男85.010425丁25女82.010426丁26男81.010427丁27男70.010428丁28男77.010429丁29男78.010430丁30男83.010431丁31男77.010432丁32男77.010433丁33女78.010434丁34男77.010435丁35男81.010436丁36女82.010437丁37男75.010438丁38男69.010439丁39女79.010440丁40女75.010441丁41男77.010442丁42女56.010443丁43女62.010444丁44男83.010445丁45男71.010446丁46男74.010447丁47女83.010448丁48男52.010449丁49男73.010450丁50男64.010451丁51女76.010452丁52女79.010453丁53男74.010454丁54女85.010455丁55男67.010456丁56女72.010457丁57女73.010458丁58女70.010459丁59男72.010460丁60女82.010461丁61女72.010462丁62女76.034、VLOOKUP回目录查询丁4852丁5773丁5870丁5972丁6082丁6172重庆市渝中支行01:正常用法1:60428913.37说明:SUMPRODUCT(--(条件1)，--（条件2)，（求和区域））重庆市江北支行01:法人贷款减值00:单项计提02:关注用法2:60428913.37说明:SUMPRODUCT((条件1)*（条件2)，（求和区域））02:个人贷款减值01:对公组合03:次级用法3:60428913.37说明:SUMPRODUCT((条件1)*（条件3)*（求和区域））02:个人住房贷款04:可疑用法4:60428913.37说明:条件可直接录入。如：$E$32:$E$672="重庆市渝中支行"重庆市渝中支行否01:法人贷款减值00:单项计提04:可疑60.74%56,428,913.37回目录重庆市渝中支行否01:法人贷款减值00:单项计提05:损失100.00%4,000,000.00重庆市江北支行否01:法人贷款减值00:单项计提04:可疑55.47%35,893,830.98重庆市九龙坡支行否01:法人贷款减值00:单项计提03:次级27.61%68,609,747.13重庆市南岸支行否01:法人贷款减值00:单项计提03:次级25.00%21,185,000.00重庆市江津支行否01:法人贷款减值00:单项计提03:次级26.52%4,495,760.31重庆市合川支行否01:法人贷款减值00:单项计提04:可疑68.00%10,200,000.00重庆市潼南支行是01:法人贷款减值00:单项计提04:可疑68.42%49,877,426.29重庆市潼南支行是01:法人贷款减值00:单项计提05:损失92.09%4,179,853.81重庆市永川支行否01:法人贷款减值00:单项计提03:次级33.20%1,394,335.93重庆市永川支行否01:法人贷款减值00:单项计提04:可疑75.01%742,562.04重庆市永川支行否01:法人贷款减值00:单项计提05:损失100.00%380,000.00重庆市铜梁支行是01:法人贷款减值00:单项计提05:损失90.00%720,000.00重庆市璧山支行是01:法人贷款减值00:单项计提03:次级25.00%74,815.50重庆两江新区支行否01:法人贷款减值00:单项计提04:可疑66.86%1,303,717.69重庆市垫江支行是01:法人贷款减值00:单项计提03:次级25.28%631,941.57重庆市垫江支行是01:法人贷款减值00:单项计提04:可疑50.14%1,288,552.50重庆市南川支行否01:法人贷款减值00:单项计提05:损失92.02%1,612,338.86重庆市丰都支行是01:法人贷款减值00:单项计提04:可疑51.75%8,580,522.55重庆市武隆支行是01:法人贷款减值00:单项计提04:可疑51.84%11,793,696.84重庆市武隆支行是01:法人贷款减值00:单项计提05:损失90.40%2,014,074.19重庆市开县支行是01:法人贷款减值00:单项计提04:可疑63.88%4,982,542.07重庆市开县支行是01:法人贷款减值00:单项计提05:损失97.60%4,486,384.29重庆市忠县支行是01:法人贷款减值00:单项计提04:可疑81.94%8,177,860.14重庆市巫山支行是01:法人贷款减值00:单项计提04:可疑76.18%9,420,220.07重庆市彭水支行是01:法人贷款减值00:单项计提03:次级25.02%3,555,622.63重庆市秀山支行是01:法人贷款减值00:单项计提03:次级10.11%2,063,453.85涪陵分行城区支行否01:法人贷款减值00:单项计提04:可疑72.41%135,409,006.37涪陵分行营业部否01:法人贷款减值00:单项计提05:损失91.19%1,171,243.70万州分行营业部否01:法人贷款减值00:单项计提03:次级25.00%10,268,153.99万州分行营业部否01:法人贷款减值00:单项计提04:可疑68.24%4,071,399.05重庆市渝中支行否01:法人贷款减值01:对公组合01:正常1.05%158,950,944.92重庆市渝中支行否01:法人贷款减值01:对公组合02:关注4.50%1,931,400.00重庆市江北支行否01:法人贷款减值01:对公组合01:正常1.05%49,477,299.27重庆市江北支行否01:法人贷款减值01:对公组合02:关注4.50%22,792,500.00重庆市沙坪坝支行否01:法人贷款减值01:对公组合01:正常1.05%50,253,926.22重庆市沙坪坝支行否01:法人贷款减值01:对公组合02:关注4.50%11,542,500.00重庆市九龙坡支行否01:法人贷款减值01:对公组合01:正常1.05%45,156,171.86重庆市九龙坡支行否01:法人贷款减值01:对公组合02:关注4.50%19,170,000.00重庆市南岸支行否01:法人贷款减值01:对公组合01:正常1.05%59,656,166.09重庆市南岸支行否01:法人贷款减值01:对公组合02:关注4.50%435,015.00重庆市北碚支行否01:法人贷款减值01:对公组合01:正常1.05%35,489,288.74重庆市北碚支行否01:法人贷款减值01:对公组合02:关注4.50%21,675,600.00重庆市巴南支行否01:法人贷款减值01:对公组合01:正常1.05%36,147,248.00重庆市巴南支行否01:法人贷款减值01:对公组合02:关注4.50%1,908,000.00重庆市綦江支行是01:法人贷款减值01:对公组合01:正常1.05%15,617,675.16重庆市綦江支行是01:法人贷款减值01:对公组合02:关注4.50%3,591,000.00重庆长寿支行否01:法人贷款减值01:对公组合01:正常1.05%24,749,654.44重庆长寿支行否01:法人贷款减值01:对公组合02:关注4.50%2,106,000.00重庆市渝北支行否01:法人贷款减值01:对公组合01:正常1.05%100,844,037.75重庆市渝北支行否01:法人贷款减值01:对公组合02:关注4.50%3,049,650.00重庆市江津支行否01:法人贷款减值01:对公组合01:正常1.05%33,737,790.14重庆市江津支行否01:法人贷款减值01:对公组合02:关注4.50%1,747,729.32重庆市合川支行否01:法人贷款减值01:对公组合01:正常1.05%26,810,050.37重庆市合川支行否01:法人贷款减值01:对公组合02:关注4.50%805,500.00重庆市潼南支行是01:法人贷款减值01:对公组合01:正常1.05%10,324,179.83重庆市潼南支行是01:法人贷款减值01:对公组合02:关注4.50%1,271,250.00重庆市永川支行否01:法人贷款减值01:对公组合01:正常1.05%16,729,547.19重庆市永川支行否01:法人贷款减值01:对公组合02:关注4.50%63,000.00重庆市荣昌支行是01:法人贷款减值01:对公组合01:正常1.05%7,758,429.65重庆市荣昌支行是01:法人贷款减值01:对公组合02:关注4.50%117,000.00重庆市铜梁支行是01:法人贷款减值01:对公组合01:正常1.05%5,970,825.00重庆市铜梁支行是01:法人贷款减值01:对公组合02:关注4.50%1,280,250.00重庆市璧山支行是01:法人贷款减值01:对公组合01:正常1.05%19,268,991.82重庆市大足支行是01:法人贷款减值01:对公组合01:正常1.05%11,982,806.49重庆市大足支行是01:法人贷款减值01:对公组合02:关注4.50%4,905,000.00重庆两江新区支行否01:法人贷款减值01:对公组合01:正常1.05%27,113,235.08重庆市分行营业部否01:法人贷款减值01:对公组合01:正常1.05%21,014,805.00重庆市万盛支行否01:法人贷款减值01:对公组合01:正常1.05%9,797,673.85重庆市大渡口支行否01:法人贷款减值01:对公组合01:正常1.05%35,102,364.27重庆市大渡口支行否01:法人贷款减值01:对公组合02:关注4.50%3,150,000.00重庆市双桥支行否01:法人贷款减值01:对公组合01:正常1.05%1,954,455.23重庆市微电子园支行否01:法人贷款减值01:对公组合01:正常1.05%4,200,000.00重庆市保税港支行否01:法人贷款减值01:对公组合01:正常1.05%3,360,000.00重庆市垫江支行是01:法人贷款减值01:对公组合01:正常1.05%6,395,550.00重庆市垫江支行是01:法人贷款减值01:对公组合02:关注4.50%1,879,650.00重庆市南川支行否01:法人贷款减值01:对公组合01:正常1.05%23,589,662.66重庆市南川支行否01:法人贷款减值01:对公组合02:关注4.50%20,654,100.00重庆市丰都支行是01:法人贷款减值01:对公组合01:正常1.05%8,177,820.00重庆市丰都支行是01:法人贷款减值01:对公组合02:关注4.50%2,377,440.00重庆市武隆支行是01:法人贷款减值01:对公组合01:正常1.05%18,473,700.00重庆市武隆支行是01:法人贷款减值01:对公组合02:关注4.50%11,164,500.00重庆市开县支行是01:法人贷款减值01:对公组合01:正常1.05%2,791,607.88重庆市开县支行是01:法人贷款减值01:对公组合02:关注4.50%5,490,000.00重庆市忠县支行是01:法人贷款减值01:对公组合01:正常1.05%2,795,100.00重庆市忠县支行是01:法人贷款减值01:对公组合02:关注4.50%1,911,600.00重庆市梁平支行是01:法人贷款减值01:对公组合01:正常1.05%6,109,950.00重庆市梁平支行是01:法人贷款减值01:对公组合02:关注4.50%180,000.00重庆市云阳支行是01:法人贷款减值01:对公组合01:正常1.05%7,308,000.00重庆市云阳支行是01:法人贷款减值01:对公组合02:关注4.50%180,000.00重庆市奉节支行是01:法人贷款减值01:对公组合01:正常1.05%6,743,945.36重庆市巫山支行是01:法人贷款减值01:对公组合01:正常1.05%3,586,505.02重庆市巫山支行是01:法人贷款减值01:对公组合02:关注4.50%2,250,000.00重庆市巫溪支行是01:法人贷款减值01:对公组合01:正常1.05%5,185,425.00重庆市巫溪支行是01:法人贷款减值01:对公组合02:关注4.50%564,750.00重庆市城口支行是01:法人贷款减值01:对公组合01:正常1.05%8,284,500.00重庆市城口支行是01:法人贷款减值01:对公组合02:关注4.50%1,669,500.00重庆市石柱支行是01:法人贷款减值01:对公组合01:正常1.05%9,669,450.00重庆市石柱支行是01:法人贷款减值01:对公组合02:关注4.50%3,600,000.00重庆市彭水支行是01:法人贷款减值01:对公组合01:正常1.05%32,815,596.08重庆市彭水支行是01:法人贷款减值01:对公组合02:关注4.50%10,462,500.00重庆市酉阳支行是01:法人贷款减值01:对公组合01:正常1.05%7,357,350.00重庆市酉阳支行是01:法人贷款减值01:对公组合02:关注4.50%405,000.00重庆市秀山支行是01:法人贷款减值01:对公组合01:正常1.05%7,959,000.00重庆市秀山支行是01:法人贷款减值01:对公组合02:关注4.50%5,850,000.00重庆分行本部业务否01:法人贷款减值01:对公组合01:正常1.05%90,125,744.04重庆分行本部业务否01:法人贷款减值01:对公组合02:关注4.50%202,500.00涪陵分行城区支行否01:法人贷款减值01:对公组合01:正常1.05%247,275.00涪陵分行营业部否01:法人贷款减值01:对公组合01:正常1.05%30,798,749.57涪陵分行营业部否01:法人贷款减值01:对公组合02:关注4.50%4,351,500.00万州分行营业部否01:法人贷款减值01:对公组合01:正常1.05%33,170,804.52万州分行营业部否01:法人贷款减值01:对公组合02:关注4.50%10,080,000.00黔江分行营业部否01:法人贷款减值01:对公组合01:正常1.05%12,481,675.50黔江分行营业部否01:法人贷款减值01:对公组合02:关注4.50%288,000.00重庆市渝中支行否02:个人贷款减值04:个人经营贷款01:正常0.60%498,820.79重庆市渝中支行否02:个人贷款减值03:个人消费贷款01:正常0.60%3,929,194.82重庆市渝中支行否02:个人贷款减值02:个人住房贷款01:正常0.12%3,793,537.96重庆市渝中支行否02:个人贷款减值06:个人其他贷款01:正常15.67%16,039,921.78重庆市渝中支行否02:个人贷款减值04:个人经营贷款02:关注3.30%71,837.64重庆市渝中支行否02:个人贷款减值03:个人消费贷款02:关注3.04%900,912.55重庆市渝中支行否02:个人贷款减值02:个人住房贷款02:关注1.10%1,697,647.31重庆市渝中支行否02:个人贷款减值06:个人其他贷款02:关注58.13%186,192.99重庆市渝中支行否02:个人贷款减值04:个人经营贷款03:次级15.66%911,620.71重庆市渝中支行否02:个人贷款减值03:个人消费贷款03:次级47.41%346,480.70重庆市渝中支行否02:个人贷款减值02:个人住房贷款03:次级13.21%1,670,008.63重庆市渝中支行否02:个人贷款减值06:个人其他贷款03:次级59.76%3,357,168.62重庆市渝中支行否02:个人贷款减值04:个人经营贷款04:可疑80.78%29,336.00重庆市渝中支行否02:个人贷款减值03:个人消费贷款04:可疑65.16%1,584,524.88重庆市渝中支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%6,223,022.58重庆市渝中支行否02:个人贷款减值06:个人其他贷款04:可疑63.59%2,527,333.26重庆市渝中支行否02:个人贷款减值04:个人经营贷款05:损失100.00%4,119.42重庆市渝中支行否02:个人贷款减值03:个人消费贷款05:损失100.00%3,377,304.35重庆市渝中支行否02:个人贷款减值02:个人住房贷款05:损失100.00%8,194,399.03重庆市渝中支行否02:个人贷款减值06:个人其他贷款05:损失100.00%11,262,674.78重庆市江北支行否02:个人贷款减值04:个人经营贷款01:正常0.60%190,299.93重庆市江北支行否02:个人贷款减值03:个人消费贷款01:正常0.60%301,511.82重庆市江北支行否02:个人贷款减值02:个人住房贷款01:正常0.12%1,248,960.30重庆市江北支行否02:个人贷款减值06:个人其他贷款01:正常15.67%4,006,695.12重庆市江北支行否02:个人贷款减值04:个人经营贷款02:关注3.30%103,477.11重庆市江北支行否02:个人贷款减值03:个人消费贷款02:关注3.04%15,115.54重庆市江北支行否02:个人贷款减值02:个人住房贷款02:关注1.10%391,128.78重庆市江北支行否02:个人贷款减值05:个人农户贷款02:关注0.96%285.97重庆市江北支行否02:个人贷款减值06:个人其他贷款02:关注58.13%116,774.13重庆市江北支行否02:个人贷款减值02:个人住房贷款03:次级13.21%335,211.72重庆市江北支行否02:个人贷款减值06:个人其他贷款03:次级59.76%7,244.91重庆市江北支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%283,659.87重庆市江北支行否02:个人贷款减值06:个人其他贷款04:可疑63.59%21,317.63重庆市江北支行否02:个人贷款减值04:个人经营贷款05:损失100.00%1,544,954.87重庆市江北支行否02:个人贷款减值03:个人消费贷款05:损失100.00%101,402.30重庆市江北支行否02:个人贷款减值02:个人住房贷款05:损失100.00%571,641.24重庆市江北支行否02:个人贷款减值06:个人其他贷款05:损失100.00%504,254.50重庆市沙坪坝支行否02:个人贷款减值04:个人经营贷款01:正常0.60%46,893.51重庆市沙坪坝支行否02:个人贷款减值03:个人消费贷款01:正常0.60%109,235.67重庆市沙坪坝支行否02:个人贷款减值02:个人住房贷款01:正常0.12%1,729,774.92重庆市沙坪坝支行否02:个人贷款减值06:个人其他贷款01:正常15.67%3,417,938.64重庆市沙坪坝支行否02:个人贷款减值04:个人经营贷款02:关注3.30%1,462.05重庆市沙坪坝支行否02:个人贷款减值03:个人消费贷款02:关注3.04%52,198.73重庆市沙坪坝支行否02:个人贷款减值02:个人住房贷款02:关注1.10%621,591.64重庆市沙坪坝支行否02:个人贷款减值06:个人其他贷款02:关注58.13%349,426.04重庆市沙坪坝支行否02:个人贷款减值03:个人消费贷款03:次级47.41%15,915.74重庆市沙坪坝支行否02:个人贷款减值02:个人住房贷款03:次级13.21%436,309.02重庆市沙坪坝支行否02:个人贷款减值06:个人其他贷款03:次级59.76%562,121.98重庆市沙坪坝支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%450,139.58重庆市沙坪坝支行否02:个人贷款减值06:个人其他贷款04:可疑63.59%986,853.79重庆市沙坪坝支行否02:个人贷款减值06:个人其他贷款05:损失100.00%2,296,146.54重庆市九龙坡支行否02:个人贷款减值04:个人经营贷款01:正常0.60%19,225.75重庆市九龙坡支行否02:个人贷款减值03:个人消费贷款01:正常0.60%58,075.58重庆市九龙坡支行否02:个人贷款减值02:个人住房贷款01:正常0.12%1,133,506.83重庆市九龙坡支行否02:个人贷款减值06:个人其他贷款01:正常15.67%7,303,956.03重庆市九龙坡支行否02:个人贷款减值04:个人经营贷款02:关注3.30%20,560.64重庆市九龙坡支行否02:个人贷款减值03:个人消费贷款02:关注3.04%10,383.14重庆市九龙坡支行否02:个人贷款减值02:个人住房贷款02:关注1.10%341,985.90重庆市九龙坡支行否02:个人贷款减值06:个人其他贷款02:关注58.13%134,599.09重庆市九龙坡支行否02:个人贷款减值03:个人消费贷款03:次级47.41%212,944.62重庆市九龙坡支行否02:个人贷款减值02:个人住房贷款03:次级13.21%235,941.86重庆市九龙坡支行否02:个人贷款减值06:个人其他贷款03:次级59.76%3,139,789.08重庆市九龙坡支行否02:个人贷款减值03:个人消费贷款04:可疑65.16%249,699.08重庆市九龙坡支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%232,832.67重庆市九龙坡支行否02:个人贷款减值06:个人其他贷款04:可疑63.59%874,444.36重庆市九龙坡支行否02:个人贷款减值03:个人消费贷款05:损失100.00%7,189,256.45重庆市九龙坡支行否02:个人贷款减值02:个人住房贷款05:损失100.00%688,226.84重庆市九龙坡支行否02:个人贷款减值06:个人其他贷款05:损失100.00%7,419,406.52重庆市南岸支行否02:个人贷款减值04:个人经营贷款01:正常0.60%186,321.29重庆市南岸支行否02:个人贷款减值03:个人消费贷款01:正常0.60%711,188.53重庆市南岸支行否02:个人贷款减值02:个人住房贷款01:正常0.12%1,815,940.66重庆市南岸支行否02:个人贷款减值06:个人其他贷款01:正常15.67%7,567,073.79重庆市南岸支行否02:个人贷款减值04:个人经营贷款02:关注3.30%15,773.70重庆市南岸支行否02:个人贷款减值03:个人消费贷款02:关注3.04%64,364.48重庆市南岸支行否02:个人贷款减值02:个人住房贷款02:关注1.10%614,203.88重庆市南岸支行否02:个人贷款减值05:个人农户贷款02:关注0.96%286.76重庆市南岸支行否02:个人贷款减值06:个人其他贷款02:关注58.13%340,774.49重庆市南岸支行否02:个人贷款减值03:个人消费贷款03:次级47.41%49,005.20重庆市南岸支行否02:个人贷款减值02:个人住房贷款03:次级13.21%649,007.97重庆市南岸支行否02:个人贷款减值06:个人其他贷款03:次级59.76%2,155,678.92重庆市南岸支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%204,397.72重庆市南岸支行否02:个人贷款减值06:个人其他贷款04:可疑63.59%624,745.06重庆市南岸支行否02:个人贷款减值02:个人住房贷款05:损失100.00%287,001.72重庆市南岸支行否02:个人贷款减值06:个人其他贷款05:损失100.00%7,827,252.96重庆市北碚支行否02:个人贷款减值04:个人经营贷款01:正常0.60%335,287.76重庆市北碚支行否02:个人贷款减值03:个人消费贷款01:正常0.60%64,254.37重庆市北碚支行否02:个人贷款减值02:个人住房贷款01:正常0.12%1,137,755.91重庆市北碚支行否02:个人贷款减值06:个人其他贷款01:正常15.67%1,231,250.58重庆市北碚支行否02:个人贷款减值04:个人经营贷款02:关注3.30%9,669.81重庆市北碚支行否02:个人贷款减值02:个人住房贷款02:关注1.10%176,947.52重庆市北碚支行否02:个人贷款减值06:个人其他贷款02:关注58.13%128,007.10重庆市北碚支行否02:个人贷款减值02:个人住房贷款03:次级13.21%114,082.20重庆市北碚支行否02:个人贷款减值06:个人其他贷款03:次级59.76%136,208.72重庆市北碚支行否02:个人贷款减值06:个人其他贷款04:可疑63.59%362,834.78重庆市北碚支行否02:个人贷款减值04:个人经营贷款05:损失100.00%1,827,949.38重庆市北碚支行否02:个人贷款减值05:个人农户贷款05:损失100.00%8,681.30重庆市北碚支行否02:个人贷款减值06:个人其他贷款05:损失100.00%4,885,323.39重庆市巴南支行否02:个人贷款减值04:个人经营贷款01:正常0.60%115,006.47重庆市巴南支行否02:个人贷款减值03:个人消费贷款01:正常0.60%177,273.39重庆市巴南支行否02:个人贷款减值02:个人住房贷款01:正常0.12%1,409,271.50重庆市巴南支行否02:个人贷款减值06:个人其他贷款01:正常15.67%5,915,341.49重庆市巴南支行否02:个人贷款减值04:个人经营贷款02:关注3.30%15,275.07重庆市巴南支行否02:个人贷款减值03:个人消费贷款02:关注3.04%1,387.28重庆市巴南支行否02:个人贷款减值02:个人住房贷款02:关注1.10%403,618.06重庆市巴南支行否02:个人贷款减值05:个人农户贷款02:关注0.96%955.87重庆市巴南支行否02:个人贷款减值06:个人其他贷款02:关注58.13%130,101.00重庆市巴南支行否02:个人贷款减值02:个人住房贷款03:次级13.21%334,508.85重庆市巴南支行否02:个人贷款减值06:个人其他贷款03:次级59.76%1,358,683.78重庆市巴南支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%453,286.82重庆市巴南支行否02:个人贷款减值06:个人其他贷款04:可疑63.59%628,644.32重庆市巴南支行否02:个人贷款减值02:个人住房贷款05:损失100.00%16,295.00重庆市巴南支行否02:个人贷款减值06:个人其他贷款05:损失100.00%7,178,360.12重庆市綦江支行是02:个人贷款减值04:个人经营贷款01:正常0.60%244,466.87重庆市綦江支行是02:个人贷款减值03:个人消费贷款01:正常0.60%37,807.91重庆市綦江支行是02:个人贷款减值02:个人住房贷款01:正常0.12%615,018.67重庆市綦江支行是02:个人贷款减值03:个人消费贷款02:关注3.04%9,974.75重庆市綦江支行是02:个人贷款减值02:个人住房贷款02:关注1.10%125,784.86重庆市綦江支行是02:个人贷款减值05:个人农户贷款02:关注0.96%667.60重庆市綦江支行是02:个人贷款减值02:个人住房贷款03:次级13.21%101,791.09重庆市綦江支行是02:个人贷款减值05:个人农户贷款03:次级58.68%1,406,439.15重庆市綦江支行是02:个人贷款减值03:个人消费贷款04:可疑65.16%244,241.83重庆市綦江支行是02:个人贷款减值02:个人住房贷款04:可疑47.33%94,196.81重庆市綦江支行是02:个人贷款减值05:个人农户贷款04:可疑68.29%146,169.77重庆市綦江支行是02:个人贷款减值03:个人消费贷款05:损失100.00%931,416.69重庆长寿支行否02:个人贷款减值04:个人经营贷款01:正常0.60%17,939.12重庆长寿支行否02:个人贷款减值03:个人消费贷款01:正常0.60%786.39重庆长寿支行否02:个人贷款减值02:个人住房贷款01:正常0.12%404,362.78重庆长寿支行否02:个人贷款减值06:个人其他贷款01:正常15.67%232,186.19重庆长寿支行否02:个人贷款减值04:个人经营贷款02:关注3.30%8,537.51重庆长寿支行否02:个人贷款减值02:个人住房贷款02:关注1.10%89,422.58重庆长寿支行否02:个人贷款减值02:个人住房贷款03:次级13.21%19,473.21重庆长寿支行否02:个人贷款减值05:个人农户贷款03:次级58.68%982,938.87重庆长寿支行否02:个人贷款减值05:个人农户贷款04:可疑68.29%9,560.35重庆市渝北支行否02:个人贷款减值04:个人经营贷款01:正常0.60%236,229.89重庆市渝北支行否02:个人贷款减值03:个人消费贷款01:正常0.60%1,284,643.06重庆市渝北支行否02:个人贷款减值02:个人住房贷款01:正常0.12%4,383,302.82重庆市渝北支行否02:个人贷款减值06:个人其他贷款01:正常15.67%1,154,254.93重庆市渝北支行否02:个人贷款减值04:个人经营贷款02:关注3.30%66,635.16重庆市渝北支行否02:个人贷款减值03:个人消费贷款02:关注3.04%39,479.72重庆市渝北支行否02:个人贷款减值02:个人住房贷款02:关注1.10%1,802,679.99重庆市渝北支行否02:个人贷款减值05:个人农户贷款02:关注0.96%295.13重庆市渝北支行否02:个人贷款减值04:个人经营贷款03:次级15.66%36,552.78重庆市渝北支行否02:个人贷款减值02:个人住房贷款03:次级13.21%1,542,134.76重庆市渝北支行否02:个人贷款减值05:个人农户贷款03:次级58.68%17,566.24重庆市渝北支行否02:个人贷款减值04:个人经营贷款04:可疑80.78%299,286.66重庆市渝北支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%2,016,013.36重庆市渝北支行否02:个人贷款减值02:个人住房贷款05:损失100.00%1,055,301.60重庆市江津支行否02:个人贷款减值04:个人经营贷款01:正常0.60%375,347.53重庆市江津支行否02:个人贷款减值03:个人消费贷款01:正常0.60%341,995.07重庆市江津支行否02:个人贷款减值02:个人住房贷款01:正常0.12%978,195.27重庆市江津支行否02:个人贷款减值06:个人其他贷款01:正常15.67%23,361.48重庆市江津支行否02:个人贷款减值04:个人经营贷款02:关注3.30%2,816.32重庆市江津支行否02:个人贷款减值03:个人消费贷款02:关注3.04%58,927.64重庆市江津支行否02:个人贷款减值02:个人住房贷款02:关注1.10%228,119.75重庆市江津支行否02:个人贷款减值05:个人农户贷款02:关注0.96%286.76重庆市江津支行否02:个人贷款减值03:个人消费贷款03:次级47.41%438,378.28重庆市江津支行否02:个人贷款减值02:个人住房贷款03:次级13.21%101,739.26重庆市江津支行否02:个人贷款减值05:个人农户贷款03:次级58.68%53,792.28重庆市江津支行否02:个人贷款减值03:个人消费贷款04:可疑65.16%201,990.65重庆市江津支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%127,483.78重庆市江津支行否02:个人贷款减值05:个人农户贷款04:可疑68.29%2,045.89重庆市江津支行否02:个人贷款减值03:个人消费贷款05:损失100.00%28,070.00重庆市江津支行否02:个人贷款减值02:个人住房贷款05:损失100.00%107,295.22重庆市合川支行否02:个人贷款减值04:个人经营贷款01:正常0.60%121,260.28重庆市合川支行否02:个人贷款减值03:个人消费贷款01:正常0.60%46,477.72重庆市合川支行否02:个人贷款减值02:个人住房贷款01:正常0.12%694,096.40重庆市合川支行否02:个人贷款减值06:个人其他贷款01:正常15.67%338,950.63重庆市合川支行否02:个人贷款减值04:个人经营贷款02:关注3.30%12,244.66重庆市合川支行否02:个人贷款减值03:个人消费贷款02:关注3.04%7,750.89重庆市合川支行否02:个人贷款减值02:个人住房贷款02:关注1.10%167,557.07重庆市合川支行否02:个人贷款减值05:个人农户贷款02:关注0.96%2,772.03重庆市合川支行否02:个人贷款减值03:个人消费贷款03:次级47.41%16,788.54重庆市合川支行否02:个人贷款减值02:个人住房贷款03:次级13.21%100,547.24重庆市合川支行否02:个人贷款减值05:个人农户贷款03:次级58.68%244,116.38重庆市合川支行否02:个人贷款减值03:个人消费贷款04:可疑65.16%87,963.67重庆市合川支行否02:个人贷款减值02:个人住房贷款04:可疑47.33%482,454.45重庆市合川支行否02:个人贷款减值05:个人农户贷款04:可疑68.29%44,231.67重庆市潼南支行是02:个人贷款减值04:个人经营贷款01:正常0.60%39,657.85重庆市潼南支行是02:个人贷款减值03:个人消费贷款01:正常0.60%121,099.83重庆市潼南支行是02:个人贷款减值02:个人住房贷款01:正常0.12%166,216.35重庆市潼南支行是02:个人贷款减值04:个人经营贷款02:关注3.30%5,440.16重庆市潼南支行是02:个人贷款减值02:个人住房贷款02:关注1.10%20,337.68重庆市潼南支行是02:个人贷款减值05:个人农户贷款02:关注0.96%3,679.15重庆市潼南支行是02:个人贷款减值02:个人住房贷款03:次级13.21%7,959.96重庆市潼南支行是02:个人贷款减值05:个人农户贷款03:次级58.68%244,396.93重庆市潼南支行是02:个人贷款减值03:个人消费贷款05:损失100.00%2,000.00重庆市潼南支行是02:个人贷款减值05:个人农户贷款05:损失100.00%2,000.00重庆市永川支行否02:个人贷款减值04:个人经营贷款01:正常0.60%120,361.66重庆市永川支行否02:个人贷款减值03:个人消费贷款01:正常0.60%591,990.10重庆市永川支行否02:个人贷款减值0