Solve : Excel formula's?

1.	Solve : Excel formula's?
Answer» Hi. I'm having trouble TRYING to work out a formula on Microsoft excel. In column two, row 3 I need to know: If figure in column one, row 3 Is less than 1.00 = 2, if more than 1.00 but less than 2.00 = 3, if more than 2.00 but less than 3.00 = 4 and if more than 3.00 = 13. Does this make sense to anyone? GillThe formula in cell B3 would look like this: =IF(A3&LT;1,2,IF(AND(A3>=1,A3<=2),3,IF(AND(A3>=2,A3<=3),4,IF(A3>3,13,)))) This formula assumes a numeric value is in cell A3 and doesn't do any ERROR checking.Thank you very much

Discussion