Formula Help Required

[VinodKrishnappa]

Hi,

In the following situation i need some formula help.

[TABLE="width: 400"]
<colgroup><col width="80" span="5" style="width:60pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 80, align: right"][TABLE="width: 500"]
<tbody>[TR]
[TD]25[/TD]
[TD]1[/TD]
[TD]10[/TD]
[TD]No[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11[/TD]
[TD]20[/TD]
[TD]No[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]21[/TD]
[TD]30[/TD]
[TD]Yes[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]31[/TD]
[TD]40[/TD]
[TD]No[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]41[/TD]
[TD]50[/TD]
[TD]No[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD="class: xl64, width: 80, align: right"][/TD]
[TD="class: xl64, width: 80, align: right"][/TD]
[TD="class: xl65, width: 80"][/TD]
[TD="class: xl65, width: 80"][/TD]
[/TR]
</tbody>[/TABLE]
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...


[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

A​

[/td][td="bgcolor: #DCE6F1"]

B​

[/td][td="bgcolor: #DCE6F1"]

C​

[/td][td="bgcolor: #DCE6F1"]

D​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

25​

[/td][td]

1​

[/td][td]

10​

[/td][td]

Yes​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td][/td][td]

11​

[/td][td]

20​

[/td][td]

Yes​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td][/td][td]

21​

[/td][td]

30​

[/td][td]

Yes​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td][/td][td]

31​

[/td][td]

40​

[/td][td]

No​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td][/td][td]

41​

[/td][td]

50​

[/td][td]

No​

[/td][/tr]
[/table]

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

M.