Index Match negative number (%)?

[hstef]

Hi,

Can the below formula (Ctrl Shift Enter) work with negative numbers (percentages)?
I need the formula to return the first negative percentage between -2% and -3%.

=INDEX(C2:C100,MATCH(1,(C2:C100>=0.02)*(C2:C100<=0.03),0))
Example
-0.10
-0.19
-2.1
-3.8
-2.2

Can this be done?

Thank you kindly,
Stef.

 

[Phuoc]

Book1
	A	B	C
1	-2.10%
2
3			2.30%
4			-2.10%
5			-2.20%
Sheet1

Cell Formulas
Range	Formula
A1	A1	=INDEX(C2:C100,MATCH(1,(C2:C100>=-0.03)*(C2:C100<=-0.02),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[hstef]

Hi,

It's perfect.
Thank you very much!