hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,215
- Office Version
- 2010
- Platform
- Windows
- Mobile
Formula required in F2.
Sheet1
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
Conditions:
IF B2>D2 then 1 else
IF B2<=D2 AND >C2 then 2 else
IF B2>=E2 AND <C2 then 3 else
IF B2<E2 then 4 else null (blank)
Thanks in adv
Sheet1
B | C | D | E | F | |
2 | 147.65 | 146.00 | 153.85 | 143.20 |
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
Conditions:
IF B2>D2 then 1 else
IF B2<=D2 AND >C2 then 2 else
IF B2>=E2 AND <C2 then 3 else
IF B2<E2 then 4 else null (blank)
Thanks in adv