This is probably more complicated than my title lets on , but hopefully not.

I am looking to Autocalculate a cost based on size range but am not sure how to write the statement.

Example:
400-1500 sqft = $11/sqft
1501-2400 sqft = $10.50/sqft
2401-2900 sqft = $9.50/sqft
2901+ sqft = $8.50/sqft

So, if A1 was the sqft column and had a value of 1000 then B1 should return $11,000 (1000x$11). If A1 was 2000sqft then B1 should return $21,000 (2000x$10.50)

Something like IF(A1>=400,11*A1,IF(A1>=1501,10.5*A1,IF(A1...
I'm not sure how to use multiple IFs with ranges as a check.

Thanks
-D