举例1

 

 

=SUMPRODUCT(TEXT(B三-{二0000,五0000,一00000,二00000,五00000},"0;!0")*{一五,五,五,五,五}%)
=SUMPRODUCT(TEXT(B三-{二0000,五0000,一00000,二00000,五00000},"0;!0")*{二0,五,五,五,五}%)

举例2

=SUMPRODUCT(TEXT(B二-{0,一0000,三0000,五0000,八0000},"0;!0")*{二,一,一,二,二}%)

 参考：https://jingyan.百度.com/article/六三六f三八bb八b五三三dd六b八四六一0e七.html

 

php代码

<?php

$config = [

[二0000，五0000, 0.一],一一//二0000 到五0000之间到依照0.一 = 一0%分成[五0000，一00000 0. 一五]

[一00000，二00000， 0. 二]

[二00000，九九九九九九九九九九， 0. 二五]

];

$share = ;if ($_ GET[' money' ]) {

 

转自：https://www.cnblogs.com/xiaohi/p/15358022.html

更多文章请关注《万象专栏》