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))"
A R JADHAV AND ASSOCIATES
Mumbai
CA Inter
View Details
SKAA & Associates
New Delhi
CA Inter
View Details
Chirag N Shah & Associates
Mumbai
CA Inter
View Details
Triveni Turbine Limited
Bengaluru
CA
View Details
Gowra Ventures Pvt Ltd
Hyderabad
CA
View Details
CAclubindia
