Thread
:
Setting up a formula (when F2<11,000)=$25
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_]
external usenet poster
Posts: 1,522
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
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]