Question

2位小数的数,整数超过3每超1计2分,小数点后面0.00—0.06计1分,0.07—0.12计2分,列公式,电子表里计算

Answer 1

=IF(A1>3,INT(A1)*2+INT((A1-INT(A1))*16)-5,0)

试试这个公式.

=IF(A1>3,INT(A1)*2+INT((A1+0.06-INT(A1))*16)-6,0)

再试试