【 计圣算法 】
天下大计，分极必合，合极必分。
=IF(((K6-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))/((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))<=0.5,((K6-((K6-D3)/1.05*5%))-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))*0.3,IF(((K6-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))/((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))<=1,((K6-((K6-D3)/1.05*5%))-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))*0.4-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3))*0.05,IF(((K6-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))/((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))<=2,((K6-((K6-D3)/1.05*5%))-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))*0.5-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3))*0.15,((K6-((K6-D3)/1.05*5%))-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))*0.6-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3))*0.35)))+((K6-D3)/1.05*5%)+((K6-D3)/1.05*5%*12%*K3)+(K6*0.05%*K3)+((K6-((K6-D3)/1.05*5%))*3%*M3)+(K6*0.05%*L3)+((K6-(D3+F3+H3)-((D3+F3)*I3)-(IF(((K6-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))/((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))<=0.5,((K6-((K6-D3)/1.05*5%))-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))*0.3,IF(((K6-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))/((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))<=1,((K6-((K6-D3)/1.05*5%))-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))*0.4-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3))*0.05,IF(((K6-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))/((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))<=2,((K6-((K6-D3)/1.05*5%))-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))*0.5-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3))*0.15,((K6-((K6-D3)/1.05*5%))-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3)))*0.6-((D3*(1+5%*E3))+(F3+G3+H3)+((D3+F3)*I3+(K6*0.05%*K3)+(K6-D3)/1.05*5%*12%*K3))*0.35)))+((K6-D3)/1.05*5%)+((K6-D3)/1.05*5%*12%*K3)+(K6*0.05%*K3)))*N3)
热门跟贴