運算式 計算二數字 (12856)

F2=CHOOSE(FIND(C2,"+-*/"),B2+D2,B2-D2,B2*D2,B2/D2)

I2=CHOOSE(LOOKUP(1,0/FIND({"+","-","*","/"},H2),{1,2,3,4}),B2+D2,B2-D2,B2*D2,B2/D2)



留言