Prev: Help: vlookup from multiple sheets and spreadhseets
Next: Delete Rows using If and Wildcard
From: Hawkeye on 16 Mar 2010 11:12
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
From: Don Guillett on 16 Mar 2010 11:25
=if(a2<11000,25,"something else")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Hawkeye" <Hawkeye(a)discussions.microsoft.com> wrote in message
news:CAEA16EE-5539-46CC-B625-1796124FFC92(a)microsoft.com...
> 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

From: RonaldoOneNil on 16 Mar 2010 11:50
=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
From: trip_to_tokyo on 16 Mar 2010 11:53
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.





"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
 | 
Pages: 1
Prev: Help: vlookup from multiple sheets and spreadhseets
Next: Delete Rows using If and Wildcard