Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with setting up a formula | Excel Discussion (Misc queries) | |||
Setting up a formula | Excel Worksheet Functions | |||
cancelling getpivot formula when setting formula outside pivot ta. | Excel Worksheet Functions | |||
Setting up a formula HELP | Excel Worksheet Functions | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) |