Simple formula required

[hsandeep]

Formula required in F2.

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

 

[Rick Rothstein]

Hi Mike, I think you also need to put a space after the < symbols

While it is a good idea to tell people this, you do not have to wait for them to do it in order to see what they posted. Click "Reply With Quote" and if your Quick Reply window is in Source Mode (first icon with the little upper case A, slash, big underlined upper case A is highlighted), you will see the exact, unprocessed layout of the originally posted message