Hello all,

I'm new here and kinda new to excel. I'm working on a spreadsheet and I've put together a formula to, basically, look at a number of cells in a column and if all the cells values are above 8, a certain dollar value will show. The problem is that the formula is very long and I didn't know if there was a way to shorten or simplify the formula. Here it is

=IF(AND(T3>9,T4>9,T5>9,T6>9,T7>9,T8>9,T9>9,T10>9,T11>9,T12>9),"$1,200.00",IF(AND(T3>10,T4>10,T5>10,T6>10,T7>10,T8>10,T9>10,T10>10,T11>10,T12>10),"$1,500.00",IF(AND(T3>11,T4>11,T5>11,T6>11,T7>11,T8>11,T9>11,T10>11,T11>11,T12>11),"$1,800.00","$1,000.00")))

You can see that In the first part, I just want T3 through T12 to be checked for a value greater than 9. Apparently, I can't just put T3:T12. You all have any ideas?

Thanks in advance