Excel 2007 : Conditional Formulas - HELP!

[willroney]

I have two columns. In the LH column, there are a load of whole (positive) numbers. I would like to populate the second column with a piece of text that denotes what range the adjacent number falls into.

The best I have come up with so far is

=OR(IF(O3<10,"LT 10"):IF(O3<50,O3>9,"10 to 49"):IF(O3<100,O3>49,"50 to 99"):IF(O3>99,"100 & OVER"))

(where O3 is the cell reference).

But...it doesn't work. Where am I going wrong?

Best Regards

Will

[sailepaty]

Try this,

=IF(O3>99,"100 & OVER",IF(O3>49,"50 to 99",IF(O3>9,"10 to 49","LT 10")))

Regards

[willroney]

Thanks for your help. Works perfectly.