Computer Hope

Microsoft => Microsoft Windows => Windows XP => Topic started by: gillian1552 on November 18, 2014, 07:45:12 AM

Title: Excel formula's
Post by: gillian1552 on November 18, 2014, 07:45:12 AM

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

Title: Re: Excel formula's
Post by: strollin on November 18, 2014, 08:33:44 AM

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.

Title: Re: Excel formula's
Post by: gillian1552 on November 19, 2014, 02:15:28 AM

Thank you very much