Help simplifying an if and formula

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

The logic is wrong.

Can you upload a sample sheet.

Here you go.

Wow. You all are awesome. I like berlans, as this makes it very easy if I add additional employees but it's nice to see that there are so many different options that are sooooooo much easier than what I constructed.

Thanks SO much

Instead of returning e.g. "$1,000.00" as a string, as in the first formula provided, consider returning it as a value and use numberformatting instead.

Why would you use the $ in the cell descriptions for berlans formula? I still don't quite understand the meaning of those when they're used

$ sign is used to intend absolute reference. When you have $ signs like in the example below, if you drag the formula to the right or down the reference will not change.

$T$3:$T$12

see the following URL for more details,

https://support.office.com/en-za/art...c-28b4151d7d21