Simple IF

[hsandeep]

B2=Either of 2 or 1
C2=Either of 1 or 0

D2=100 for B2=2 & C2=1 else 200 for B2=1 & C2=1 else 300.

Formula needed for D2?
Thanx in advance.

 

[gaz_chops]

Try

=if(and(B2=1,C2=1),200,if(and(B2=2,C2=1),100,300))

 

[hsandeep]

Try

=if(and(B2=1,C2=1),200,if(and(B2=2,C2=1),100,300))

It WORKS. Thanks

 

[gaz_chops]

You're welcome.