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))"
N J Suresh & Associates
Bengaluru
CA Inter
View Details
Saini Pati Shah & Co LLP, Chartered Accountants
Mumbai
CA Foundation
View Details
CA ANOOP P K & ASSOCIATES
Kozhikode
CA Inter
View Details
CCI
Pro
CAclubindia
