EXCEL IF 問題

注意: A1:A5中是A或B
所以: 要用埋or

if 最基本用法: =if(a1=a, "1", "2")
即係如果a1係a, show1, 否則2

加埋or
=IF(OR(a1=a, a1=b), "1", "2")

You can put this formula in cell B1, so that excel will count from range A1:A5 to see whether it has A or B. If either A or B is found within the range, it will return 1, otherwise it will return 2.

=IF(OR(COUNTIF(A1:A5, "A" )>0,COUNTIF(A1:A5, "B" )>0),1,2)

P.S. remove the symbol semi-colon (;) from the equation, for some reason it appears above. The correct formula should not have that semi-colon...........

I hope that helps.