多个条件求和

更新时间2021-08-01 01:36:57

=SUM(MOD(B2:D2,100)*(INT(B2:D2/100)+1)+(INT(B2:D2/100)+1)*INT(B2:D2/100)*50)

输完公式后，按CTRL+SHIFT+ENTER，