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

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

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hawkeye" wrote in message
...
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

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

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

"Hawkeye" wrote:

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

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

EXCEL 2007

I reckon this works:-

=IF(OR(F2="",F211000),"Not Applicable",25)

I have not tested for negative values.

If my comments have helped please hit Yes.

Thanks.





"Hawkeye" wrote:

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