Two Parameter in IF condition Formula

Rajesh Kumar (Student) (211 Points)

20 January 2009  

Hi

Can anyone tell me how to formulate if condition formula when 2 condition to be satisfied?

e.g.

Cell A 1= 20  , Cell B1 = 30 , Cell C1 = 50, Cell D1= 100

I want   if A1 = 20 and B1=30 then C1(50) else D1(100)

I hope I am clear in explaining

thanks & regards

Rajesh