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

=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

=IF(ISBLANK(B1),0,IF(A1=20,100,200))
but be careful! A dash (-) in B IS a value! If you want to mark the NO VALUE
case with dashes, then the formula is
=IF(B1="-",0,IF(A1=20,100,200))

Regards,
Stefi

€žShamsulZ€� ezt Ã*rta:

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