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

  • Thread starter Thread starter Hawkeye
  • Start date Start date
H

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
 
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.
 
Back
Top