KW2014

Q: AppleWorks and Conditional Calculations

Does Appleworks support Conditional Calculations?  Like If the Value if Column G is "MD" then Multiply the value in Column K by .92?  But if the value in Column G is "DC" then multiply the value in Column K by .95?

Posted on Mar 19, 2014 11:34 AM

Close

Q: AppleWorks and Conditional Calculations

  • All replies
  • Helpful answers

  • by Barry,

    Barry Barry Mar 19, 2014 11:45 PM in response to KW2014
    Level 7 (32,537 points)
    iWork
    Mar 19, 2014 11:45 PM in response to KW2014

    If these are the only two possible values, a simple IF statement will do the job:

     

    =IF(G2="MD",K2*0.92,K2*0.95)

     

    If other values (including an empty cell) are possible for G2, then a nested pair of IFs is needed:

     

    =IF(G2="MD",K2*0.92,IF(G2="DC",K2*0.95,"-"))

     

    This version will do the correct multiplication for each of the two permitted values in G2. For any other value in G2, the formul will place the text value "-" in its cell.

     

    Regards,

    Barry