Microsoft Excel Formula?

Question

I have a list of numbers in column C, and i want to put a formula in column D that will calculate a number based on the value in column C. For instance, if the value in column C is less than 5 i want the cell next to it (D) to calculate a 0. IF cell C's value is greater than or equal to 5 and less than or equal to 7, I want column D to calculate a 2. If C is greater than or equal to 8 and less than or equal to 9, i want D to calculate a 3. Finally if C is greater than or equal to 10, I want cell D to calculate a 5. Can anyone tell me what this formula should look like. I've tried doing it with several different functions, but can't quite get it right. Thanks

Answer 1

=IF(C1>9,5,IF(C1>7,3,IF(C1>4,2, 0)))

Try it, it works perfectly (you don't need the ands mentioned below).

Answer 2

You need to use the "IF" and the "AND" for some conditional formatting.

I started with Row 1 for my formula so you'll need to adjust accordingly.

I've put short rows in case it cuts it off due to length, but there are no spaces in this formula....ie make this one long formula

=IF(C1<5,"0",

IF(AND(C1>=5,C1<=7),"2",

IF(AND(C1>=8,C1<=9),"3",

IF(C1>=10,"5"))))