I want to use if condition for below data if column "a" matches with column "i" and column "c" matches with column "j" then the result of column "k" should get reflected in column "e"
If and condition
-
-
-
Re: If and condition
Here,
=IF(AND(A3=I3,C3=J3),K3,"-")
-
Re: If and condition
thanks for the helpbut formula is not looping in the grid
-
Re: If and condition
What do you mean by that? ... Formulas 'don't loop in a grid'.
-
Re: If and condition
i want a formula which can loop in the grid
-
-
Re: If and condition
QuoteFormulas 'don't loop in a grid'.
You COPY formulas to the cells they relate to, making sure that absolute/relative references point to the correct cells.
-
Re: If and condition
sorry for inconvenience cause from next time onward i will take care, hence kindly provide me the loop formula
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!