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
U need to use IF AND formula....
"=if(and(two conditions, True value, False Value))"
Aggarwal Sarawagi and Co
New Delhi
CA
View Details
Sri Aurobindo Gnostic Centre of Education
New Delhi
CA
View Details
Boutique Investment Bank & Transaction Advisory Firm
Gurgaon
CA
View Details
Shyam Joshi & Associates
Pune
B.Com
View Details
R P S K & Associates
Nashik
CA Inter
View Details
CAclubindia
