HT202879: About the new iWork for Mac: Features and compatibility

Learn about About the new iWork for Mac: Features and compatibility
Hans290
Level 1 (0 points)

Q: Hi, can I divide all cells in a spreadsheet with one number?

If yes, how?

MacBook Air (13-inch Mid 2012), iOS 7.1

Posted on Mar 27, 2014 8:06 AM

by Yellowbox,Solvedanswer
Yellowbox Yellowbox
Level 6 (10,485 points)
Mac OS X
A:

Hi Hans,

 

To divide every Body Cell in a table by one number (for example, divide by 2), you could do this:

 

Screen Shot 2014-03-28 at 4.39.08 pm.png

 

Formula in B2 of the "Result" table (Fiil Right and Fill Down):

 

=Original Data::B2/2

 

Another way is to add a single-cell entry table ("Divisor") for the divisor:

 

Screen Shot 2014-03-28 at 4.46.46 pm.png

 

Formula in B2 of the "Result" table (Fiil Right and Fill Down):

 

=Original Data::B2/Divisor::$A$1

 

The $ symbols preserve the divisor at A1 in the "Divisor" table as you Fill Right and Fill Down in the "Result" table.

 

The advantage of the second method is that you can quickly change the value of the divisor without editing the formulas. Save as Template for future use.

 

Regards,

Ian.

Posted on Mar 27, 2014 10:56 PM

Close
Hans290

Q: Hi, can I divide all cells in a spreadsheet with one number?

  • All replies
  • Helpful answers

  • by Jerrold Green1,Helpful

    Jerrold Green1 Jerrold Green1 Mar 27, 2014 8:11 AM in response to Hans290
    Level 7 (30,001 points)
    Mar 27, 2014 8:11 AM in response to Hans290

    No, not simply. You could make another spreadsheet, your term by which I assume you mean Table, and do the division in the references to the original table. The last step would be to Copy the second table and Paste Formula Results to solidify the conversion.

     

    Jerry

  • by Yellowbox,Solvedanswer

    Yellowbox Yellowbox Mar 27, 2014 10:56 PM in response to Hans290
    Level 6 (10,485 points)
    Mac OS X
    Mar 27, 2014 10:56 PM in response to Hans290

    Hi Hans,

     

    To divide every Body Cell in a table by one number (for example, divide by 2), you could do this:

     

    Screen Shot 2014-03-28 at 4.39.08 pm.png

     

    Formula in B2 of the "Result" table (Fiil Right and Fill Down):

     

    =Original Data::B2/2

     

    Another way is to add a single-cell entry table ("Divisor") for the divisor:

     

    Screen Shot 2014-03-28 at 4.46.46 pm.png

     

    Formula in B2 of the "Result" table (Fiil Right and Fill Down):

     

    =Original Data::B2/Divisor::$A$1

     

    The $ symbols preserve the divisor at A1 in the "Divisor" table as you Fill Right and Fill Down in the "Result" table.

     

    The advantage of the second method is that you can quickly change the value of the divisor without editing the formulas. Save as Template for future use.

     

    Regards,

    Ian.