在excel 表中用If 函数IF（A-B=0,“Yes“,“NO”）实际上A=B,但为什么返回的值去是NO呢?

在excel 表中用If 函数IF（A-B=0,“Yes“,“NO”）实际上A=B,但为什么返回的值去是NO呢? 求excel逻辑函数的应用：if（b1=a1,＂yes＂,b1＞a1,"no＂,b1＜a1,"no＂） 是否正确 Do you mind if I smoke here?选择（A Oh,no,please B Yes,please C would you mind if l keep the door open?( ).a.yes.do it b.no. DO YOU MIND IF I OPEN THE FRONT WINDOW ?A YES ,DON'T B NO,AH if you don't know the answer ,say A SO B NO C YES D IT excel中=IF(A2="","",IF(ISERROR(VLOOKUP(A2,SHEET1!A:B,2,0)),"查 一道英语选择题.Do you mind if I sit here?A.Yes,please B.No,you' EXCEL中函数=IF(B2="","","A"&TEXT(999+COUNTA(B$1:B2),"000000"))详 丨have no idea if he________.A、comes、B、come.C、wiIl come选C为什么 if(a) {if(b Do you mind if I take this seat?-___.A.No,of course not B.No