Setting up a formula (when F2<11,000)=$25

[Hawkeye]

Setting up formulas for my business on Excel 2007. I have a column for lot
sizes of properties. I need to have a second column that contains a formula
that will compute, if the 1st column is less than 11,000sf, then we will pay
$25. For example, lets say that a property is 2,500sf. The formula would
see that 2,500 is less than 11,000 and would provide an result of $25.00

 

[Don Guillett]

=if(a2<11000,25,"something else")

 

[RonaldoOneNil]

=IF(F2<11000,25,"Its Not Less")

 

[trip_to_tokyo]

EXCEL 2007

I reckon this works:-

=IF(OR(F2="",F2>11000),"Not Applicable",25)

I have not tested for negative values.

If my comments have helped please hit Yes.

Thanks.