IF/THEN statement for Numbers
I am trying to write an IF/THEN statement in Numbers, and here's the problem:
Column N displays tons: <8 costs $215, 8 or greater costs $280. I need to write an IF/THEN statement to give the monetary total per unit based on tonnage instead of trying to hand-jam it.
Tonnage | Impact Service Group Quarter 1 Cooling Season Start-up (April) | Impact Service Group Quarter 2 Cooling Season Inspection (July) | Impact Service Group Quarter 3 Heating Season Start-up (October) | Impact Service Group Quarter 4 Heating Inspection (January) | Totals per Store |
15 | $280 (more than 8) | ||||
15 | $280 | ||||
40 | $280 | ||||
5 | $215 (less than 8) |
Need this formula for work; project to turn in by COB tomorrow
MacBook Pro, iOS 5.1.1