I got help for this one finally...thank you though...maybe you can help me
with another one..if someone increases an amount by %25 then they get a point,
if they increase it by %50 they get 2 points, by %75, 3 points, and %100, 4
points.... can you figure that one out for me please?

RagDyer wrote:
How about:

=CHOOSE(--LEFT(G9),1,2,3,4,5,6,7,8,9,10)
OR
If you have numbers larger then 1,000 and smaller then 100, try this:

=CHOOSE((LEN(G9)=4)*10+(LEN(G9)=3)*LEFT(G9),1,2, 3,4,5,6,7,8,9,10)

Im working on a formula that looks somewhat like this:

[quoted text clipped - 5 lines]

WHAT AM I DOING WRONG? CAN SOMEONE PLEASE HELP ME?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1