设用电量为x度,电费为y元,y=0.65x+0.70(x-260)+0.95(x-600)
在Excel中,如列A为度数,在B2录入公示:=if(A2<=260,A2*0.65,if(and(A2>260,A2<=600),A2*0.70,if(A2>600,A2*0.95)))然后向下拖动复制。