excel，高于目标值不扣分,每低于目标值1%扣0.8分，怎么用IF语句实现

Question

如题所述

Answer 1

目标值为A1，B1为实际分值
C1=if(B1>A1,B1,B1-(B1-A1)/0.01*0.8)

Answer 2

a1为实际分,b1位标准分,扣分项为:
=if(a1>b1,0,0.8*(b1-a1)/b1)本回答被提问者采纳