On my worksheet there's one cell (let say A1), and A1=B1/C1.
And I want to create a function in cell D1 which will return the
numbers with the following conditions :
If 0<A1<=1 then D1=70%
If 1<A1<=1.4 then D1=60%
If 1.4<A1<=2 then D1=50%
If 2<A1<=2.5 then D1=30%
If 2.5<A1<=3 then D1=30%
If A13 then D1=30%

Thanks so much in advance for your help!
I need it so bad.

Hendra


--
hendra
------------------------------------------------------------------------
hendra's Profile: http://www.excelforum.com/member.php...o&userid=35516
View this thread: http://www.excelforum.com/showthread...hreadid=552889