G
Guest
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
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