Nested "IF" formula

I'm trying to simply have this nested "IF" formula yield results which just refer to values in other cells, but so far it's only yielding "FALSE".

Here is my formula so far:

B2=IF(E2<0.5,A2,IF(0.5<E2<0.7,A3,IF(0.7<E2<0.9,A4,IF(0.9<E2<1,A5))))

My goal is to yield a number, in let's say B2, that is simply copied from any one of four other cells. Now, out of those four cells which CAN be used, the one which I WANT to use is the one that meets the criteria above. So, for example, if the value of "E2" is more than .5 and also less than .7, then I want "B2" to return the value from cell "A3". If "E2" is less than .5, then I want "B2" to return the value of "A2".

But my formula apparently isn't working, it just says "FALSE"

HELP???

Oh, right, I guess the parts where I'm stating ".5<E2<.7" for example are a bit redundant because if E2 failed the firs IF test (E2<.5), then there's no need to restate that part again... so, instead, ".5<E2<.7" just turns into "E2<.7,A3.... and so on. Perhaps that was what was throwing it off??

As far as the E2>1 goes: my data will and should never even ALLOW that ever happen, so I assumed that I can just ignore that part, right??

I would like to add a sample of my spreadsheet, but I can't seem to find where on this forum will it allow me to upload an attachment..?? Sorry, I haven't used the or many other forums too often

It worked!!

I'm giving you a top-rating for quality and quick response time.

Thank you!

OK, great. Sooo, once again, how do I attach and upload a file ?

Nevermind, I found it.

Here it is...

Seems to be working fine for me now.

Ok, so, one last question.

Now, I'm just trying to add one more qualifier to that formula; one more true statement that will reference yet another cell. If it is false, THEN I want to yield the formula that you devised. Here's what I'm trying to get it too look like now:

=IF(C2<G14,A2,(E2<0.5,A2,IF(E2<0.7,A3,IF(E2<0.9,A4,IF(E2<1,A5,"E2 Greater than 1")))))

So, what I'm wanting to do is; if the number for the stock position's "VALUE" cell (C2, for example) is less than the value of the "EQUITY" cell (G14), then yield the value in cell "A2"; and if "C2" is not less than "G14", (if it's false), then I want it yield the result from the original formula we devised.

Does that makes sense?

The new part I just introduced is obviously not working. Please help?

Actually, nevermind, I figured that part out as well. I just accidentally left out the 2nd "IF"

Here it is:

=IF(C2<G14,A2,IF(E2<0.5,A2,IF(E2<0.7,A3,IF(E2<0.9,A4,IF(E2<1,A5,"E2 Greater than 1")))))

this one works