怎么用excel做选择题,判断对错?

2024-12-20 15:52:32
推荐回答(2个)
回答1:

  1. 判断K1的答案是否和J1一样就行了;

  2. L1公式:

    =IF(K1=J1,"✔","✖")

回答2:

L1输入 =IF(K1=J1,"正确","错误")