Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Numbers

M

MarkW19

macrumors 65816
Original poster
Sep 13, 2002
1,209
1
Surrey, UK
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.
 
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.
 
Virgil-TB2 said:
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.
Click to expand...

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?
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back