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))"
M N Rao & Associates LLP
Vijayawada
CA Inter
View Details
ADY & CO.
New Delhi
Graduate (Any)
View Details
HKC | Chartered Accountants & Business Advisors
Ludhiana
CA
View Details
CCI
Pro
CAclubindia
