Excel formula's

[gillian1552]

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?

Gill

[strollin]

The formula in cell B3 would look like this:

=IF(A3<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.

[gillian1552]

Thank you very much