怎样用EXCEL表计算小区停车费收费金额?答:在D2中输入如下公式 =IF(COUNTIFS(A:A,A2,B:B,">="&INT(B2),B:B,"<"&INT(B2+1))>1,IF(COUNTIFS(A$2:A2,A2,B$2:B2,">="&INT(B2),B$2:B2,"<"&INT(B2+1))=1,5,0),IF((C2-B2)*24>12,(C2-B2)*24/12*5,LOOKUP((C2-B2)*24,{0,1},{0,5})))下拉填充 ...
请教一个关于excel函数公式的问题,具体见附图:答:金额在A1单元格,收费金额输入公式 =IF(A1<0,"输入金额错误",IF(A1=0,0,IF(A1<100,50,50+MIN((A1-100)*{12,10,9,8,6,5,3,2}%+{0,2,5,10,24,33,55,68})))