Formula Help Required

[VinodKrishnappa]

Hi,

In the following situation i need some formula help.

25 1 10 No 11 20 No 21 30 Yes 31 40 No 41 50 No <tbody> </tbody>

<colgroup><col width="80" span="5" style="width:60pt"> </colgroup><tbody>
</tbody>

Cell value A1 is getting found in range between 21-30, But here i need C column value as Yes even for range 1-10 & 11-20 as well. Like if the cell value is 43 then i need C column value as YES to 1-10, 11-20, 21-30, 31-40-, 41-50. If its 2 then C column value as YES to range 1-10 only.

 

[Marcelo Branco]

Maybe...

	A​	B​	C​	D​
1​	25​	1​	10​	Yes​
2​		11​	20​	Yes​
3​		21​	30​	Yes​
4​		31​	40​	No​
5​		41​	50​	No​

Formula in D1 copied down
=IF(A$1>=B1,"Yes","No")

M.