9 Replies Latest reply: Apr 16, 2014 7:12 AM by dvo247
tessrie Level 1 Level 1 (0 points)

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