Trisha,

Assume your starting figure is in A1 & your final figure is in B1.
In C1 put
=IF(B1=A1*2,4,IF(B1=A1*1.75,3,IF(B1=A1*1.5,2,IF (B1=A1*1.25,1,0))))


Henry




"Trisha V via OfficeKB.com" wrote in message
...

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