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))"
RBSM Corporate Advisors Private Limited
Pune
CA
View Details
Interactive Media Pvt Ltd.
New Delhi
CA Inter
View Details
Getmyca Consultant Pvt Ltd
New Delhi
CA Inter
View Details
Twenty Point Nine Five Ventures Private Limited
Noida
CA Inter
View Details
CCI
Pro
CAclubindia
