Numbers

Discussion in 'Mac Apps and Mac App Store' started by MarkW19, May 30, 2008.

  1. MarkW19 macrumors 65816

    Joined:
    Sep 13, 2002
    Location:
    Surrey, UK
    #1
    I've just got Numbers, which I've found to be very good.

    But, after watching the tutorials and reading the Help pages, there are 2 things I'd love to be able to do but can't:-

    1. Add a percentage onto a SUM of a column. For instance, I have an invoice, with a column of sales totals, and a VAT row. I'd like to add up the column, THEN automatically add a VAT amount to the total of those rows and display the overall total in the total cell.

    2. I'd like to be able to specify the entire length of a group of cells in a table, and then evenly space the cells to take up that space. For instance, I want a row of cells that has a total length of 20cm from top to bottom, and want as many cells as possible to fill the 20cm equally.

    Can anyone help please?

    Thanks.
     
  2. Virgil-TB2 macrumors 65816

    Virgil-TB2

    Joined:
    Aug 3, 2007
    #2
    1. =SUM(C2:C6) * 1.35

    the sum of a cell range times a percentage.

    2. make the sheet exactly 20 cm having 20 rows of one centimetre height.

    On the second one I can't see right off where to change row height, so you might want to just make your 20 rows and then use "fit to page" in the layout mode to automatically fit it in.
     
  3. MarkW19 thread starter macrumors 65816

    Joined:
    Sep 13, 2002
    Location:
    Surrey, UK
    #3
    Nice one, thanks.

    With the VAT, is it possible to have a cell display the actual amount of VAT that has been added for the column (then to add all the cells up, inc. the VAT one) to get the final total?
     
  4. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #4
    Yes, just put into a cell (i.e. K1), then reference it.
     
  5. MarkW19 thread starter macrumors 65816

    Joined:
    Sep 13, 2002
    Location:
    Surrey, UK
    #5
    Sorry for being dumb, but how do I do that?
     
  6. blodwyn macrumors 65816

    Joined:
    Jul 28, 2004
    Location:
    Portland, Oregon
    #6
    Example:

    Cells A1:A20 contain the data
    Cell A21 calculates the VAT: =sum(A1:A20)*0.175 (or whatever the vat % is)
    Cell A22 calculates the total: =sum(A1:A20)+A21
     

Share This Page