View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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