## IF/THEN statement for Numbers

2567 Views 5 Replies Latest reply: Nov 11, 2012 9:14 AM by fan4bronco
Calculating status...
Currently Being Moderated
Aug 21, 2012 4:35 PM

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
• Level 6 (10,495 points)
Currently Being Moderated
Aug 21, 2012 4:39 PM (in response to tessrie)

=IF(N<8,215,280)

• Level 1 (0 points)
Currently Being Moderated
Nov 10, 2012 10:23 AM (in response to Badunit)

I have a similar question involving an even more complex if/then statement.  Depending upon the price entered in Column A, I want Column B to display a percentage of the value of A.  But the percentage isn't straightforward..it depends on the value of Column A.  In laymen's terms it would look like this:

IF (Column A) is LESS than \$50, THEN 15%(A)

IF (A) is between 50.01-100, THEN 10%(A)

IF (A) is GREATER than 100.01, THEN 5%(A)

Is this possible?

• Level 4 (1,890 points)
Currently Being Moderated
Nov 10, 2012 12:42 PM (in response to fan4bronco)

Try this:

=IF(A<=50,0.15*A,IF(A<=100,0.1*A,0.05*A))

• Level 7 (28,740 points)
Currently Being Moderated
Nov 10, 2012 10:56 PM (in response to fan4bronco)

You can also attack it from the opposite direction to that suggested by Jeff:

IF(A>100,0.05*A,IF(A>50,0.1*A,0.15*A))

Regards,

Barry

• Level 1 (0 points)
Currently Being Moderated
Nov 11, 2012 9:14 AM (in response to Jeff Shenk)

This worked like a charm, and I was even able to add a few more IF/THEN statements to the formula.  Thanks so much for helping a Numbers novice.

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.