Two Parameter in IF condition Formula

531 views 1 replies

Student

211 Points Joined September 2008

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

Replies (1)

A learner

185 Points Joined November 2008

U need to use IF AND formula....

"=if(and(two conditions, True value, False Value))"

Your are not logged in . Please login to post replies

Click here to Login / Register