=IF(B1="",0,IF(A1=20,100,200))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ShamsulZ" wrote in message
...
Friend, the case is like this :

A1 b1 Result (C1)

20 a 100
40 - 0
20 - 0
40 b 200

i want if b1 got any value, the the result depends on A1 - if 20 it will
result 100, otherwise results 200. if b1 got no value then automatically
c1
will be 0 and ignoring any value in a1. pls help with formula that i
should
use. thanks a lot