Add two conditions in excel Formula.

[palata123]

Hello everybodey. I have finished my formula and till now its working everything, but i need to put a second condition inside that. Here is my formula to match a specific value in a row that have 2 conditions >=1.80 and <=1.9:
Formula: {=INDEX(A2:GR2,MATCH(TRUE,INDEX((A2:GR2>=1.8),0),0))}
I dont know where and how to put the second condition *(A2:GR2<=1.9)

 

[Twollaston]

Hello everybodey. I have finished my formula and till now its working everything, but i need to put a second condition inside that. Here is my formula to match a specific value in a row that have 2 conditions >=1.80 and <=1.9:
Formula: {=INDEX(A2:GR2,MATCH(TRUE,INDEX((A2:GR2>=1.8),0),0))}
I dont know where and how to put the second condition *(A2:GR2<=1.9)

Did you try using the AND() formula?
instead of
(A2:GR2>=1.8)
you can try
AND((A2:GR2>=1.8), (A2:GR2<=1.9))

 

[palata123]

Yes i have tryed adding AND many times in different places but it returns N/A, but im sure i havent place in the right form AND.

 

[Marcelo Branco]

Try

=INDEX(A2:GR2,MATCH(1,INDEX((A2:GR2>=1.8)*(A2:GR2<=1.9),0),0))

confirmed with just Enter (no need of Ctrl+Shift+Enter)

M.

 

[palata123]

Uuuuuhhhh, mate you were so quick, thanks a lot for that, and to be honest i think i have tryed this one to becouse i remember to put that 1 after match(1 but i puted again true inside. Thanks a lot again.

 

[Marcelo Branco]

Uuuuuhhhh, mate you were so quick, thanks a lot for that, and to be honest i think i have tryed this one to becouse i remember to put that 1 after match(1 but i puted again true inside. Thanks a lot again.

You are welcome.

To use an AND condition in an array formula you should multiply the conditions - the multiplication yields an array of 1s and 0s.
Something like: {0,0,1,1,....0}. That's why i replaced TRUE by 1.

M.