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)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Trisha V via OfficeKB.com" wrote in message
...
Im working on a formula that looks somewhat like this:
=IF(G9100,1,IF(G9200,2,IF(G9300,3,)))
but it isnt working...what I need is something that says...IF (G9) IS
GREATER
THAN 100 IT WILL EQUAL 1 AND IF GREATER THAN 200, IT WILL EQUAL 2 AND
GREATER
THAN 300, ETC ETC ETC...TILL I GET TO 1000 AND 10.
WHAT AM I DOING WRONG? CAN SOMEONE PLEASE HELP ME?
|