return value

[Zhi Sheng]

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

 

[Don Guillett]

Perhaps A simple if
=if(a1>=70,30,if(a1>=40,20,if(a1>=0,10,""))))

 

[Rick Rothstein \(MVP - VB\)]

Try this formula...

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

Rick