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