Try this formula...

=IF(A1<=30,10,IF(A1<=60,20,30))

Rick


"Zhi Sheng" wrote in message
...
Hi all,

I have a column of data:
column A
0
20
30
40
60
70
90

under following criteria, i want to have column B return certain values:
0 to 30, return 10
40 to 60, return 20
70 to 100, return 30
Is there a formula that can help me to achieve this?

Thank you
--
====================
ask and you shall be answered