IF OR Function

[martyloo]

Hi I have the following problem with the following numbers in each cell

Numbers
A1 100
A2 121
A3 140
A4 98
A5 97

5% Decrease
B1 95
B2 114.95
B3 133
B4 93.1
B5 92.15

5% Increase
C1 105
C2 127.05
C3 147
C4 102.9
C5 101.85

Current Price
D1 101
D2 48
D3 56
D4 95
D5 102

Overbought/Oversold
E1 Overbought
E2 Oversold
E3
E4 Oversold
E5 Overbought

If the current price is within the 5% Increase and Decrease range and it is Overbought I want it to read "Overbought", and likewise if it is Oversold I would like it to read "Oversold"

Can anybody help me???

Thanks in advance

 

[Marcílio_Lobão]

martyloo, Good afternoon.

Try to use:

E1 --> =IF(AND(D1>=B1,D1<=C1),"OVERBOUGHT","OVERSOLD")

Copy it down.

Please, tell us if it worked for you.
I hope it helps.