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

 

[MARK858]

I think you'll find your last condition isn't complete. Try putting an empty space after the < symbol and post again.

 

[hsandeep]

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 is less than C2 then 3 else IF B2 is less than E2 then 4 else null</c2>

 

[My Aswer Is This]

Simple ??

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 is less than C2 then 3 else IF B2 is less than E2 then 4 else null</c2>

 

[hsandeep]

Your answer is WHAT?

 

[MARK858]

I must agree to a certain extent with M.A.I.T. as it does always amaze me that posters put in words like "simple" and "easy" when they are asking the question (so by default don't know the answer) so can't know whether it is simple or not.

Anyway gripe over, if I haven't missed anything try the formula below (remove the spaces).

=IF(B2>D2,1,IF(AND(B2< =D2,B2 >C2),2,IF(AND(B2>=E2,B2< C2),3,IF(B2< E2,4,""))))

 

[ukmikeb]

deleted<e2,4,if(b2<c2,3,""))))[ code]
</e2,4,if(b2<c2,3,""))))[>

 

[MARK858]

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

 

[ukmikeb]

Another version :-

=IF(B2> D2,1,IF(B2> C2,2,IF(B2< E2,4,IF(B2< C2,3,""))))

maintaining the integrity of Mark858's formula without the ANDs.

 

[ukmikeb]

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

Thanks.

There are other problems too!

Copying your formula into Excel 2007 it stripped the "=" signs!!!!