Calculating percentages using numbers

Hi timmuz79,

Not sure where you're having trouble as it works on the iPad the same as on the Mac, so Wayne's example should work.

Say you set up a table something like this:

Then double-tap in the cell where you want the formula, here D2, tap the = to enter the the formula editor:

Enter your forumula by tapping cell C2, typing ÷ , tapping cell B2, then the green check mark:

Format the cell with the formula as Percentage (Paintbrush>Format>Percentage) then tap it once and tap Fill.

After you tap Fill you will see this:

Drag the bottom border of the yellow rectangle down into the cells beneath it and you will see this:

This is all essentially the same on the Mac and the iPad.

Is this what you are trying to do?

SG

Hi SG!

I'm suffering to figure out the following function at numbers:

"Quantity

(PCS)" Unit Price Total

(USD) (USD)

1 173.7 173.7

4 173.7 694.8

3 180 540

4 159.3 637.2

This example is at invoicing, I would like to modify those amounts in that 2 columns with adding certain

Percent like 5% for example. Is ther option for it to calculate and change all those amounts with the same percentage without going one by one ? I don't even know yet how to calculate it with my additional percentage.

Thank you for helping!

Regards,

adriantoth

Hi ronzzzy,

I am not sure what you are asking.

As this thread is old and is marked as solved, please start a new question with a bit more detail. For example, tell what worked in Excel and maybe we can find the Numbers way.

Regards,

Ian.

Tim,

In cell A1 and the incomings value

In cell A2 enter the outgoings value

In cell A3 enter the formula "=A2/A1"

Not sure of the exact maechanics of how to do this on the iPAD but this should get you started. What is the specific problem you are having? the concept of percent or the mechanics of entering data and formulas on the iPAD?

Hi Adrian,

You wrote: "I need to do this with 2 column actually A and B, both column need to be added by that 5%, I think this only possible"

If I'm reading the description of your table correctly, column A shows the number of units, column B the price of each unit, and column C the price of that quantity of units.

If you increase the unit price by 5%, that will also increase the total price of n units by 5%, provided you multiply the quantity by the new unit price instead of the old unit price.

Here's a step by step:

Original table:

Formula in C2, and filled down column C: =A*B

Add a new column (D) to hold the formula for the increased price.

D2, and filled down: =B*(1+5%)

With the cells shown still selected, Copy (command-C)

Now select cell B2, and go Edit > Paste Values (Numbers '09) or Edit > Paste Formula Results (Numbers 3)

Results should be as shown below:

(Note that column C has been recalculated to show the results of a 5% increase in unit prices. Column D (labelled "temp") has also been recalculated to show what the unit prices would be after a second 5% increase. the last step is to delete this column, leaving us with the original table, but with unit prices increased by 5%:

In practice, you would probably NOT do this on the actual invoice. Item names (or numbers) and the unit prices of those items would be kept on a price list, separate from the invoice, and the price would be looked up by the Invoice table when the item name or number was entered. The table would be used as an invoice generator, and the completed invoices either printed or 'printed' as pdf files as each was generated.

Price changes would be made on the price list, either individually, or geerally as done here. Note that the new prices would affect new invoices AND any existing invoices still connected to the price list (which is why each is 'printed' to separate it from the calculating document). Here's a simple example using a price list as a lookup table. Item Number and Quantity are entered on the invoice. The rest is added by formulas.

Formulas:

Price List has no formulas.

Invoice:

C2 and filled right to column D and down to row 6:

=IFERROR(VLOOKUP($B,Price List :: $A:$C,COLUMN()-1),"")

In row 6, the empty cell in column A will cause a "could not find" error. IFERROR catches this and places a null string in C6 (and in D6).

E2 and filled down to E6: =IF(LEN(D)<1,"",A*D)

LEN(D) returns the length (in number of characters) of the contents of the cell on the same row of column D. If the cell is empty, or contains a null string (as in row 6), the length is zero, and IF will place a null string in column E.

SUM, in row seven, interprets text (including a null string) as zero, so this does not affect the sums in coumns A and E.

Row 7 is a Footer Row. Formulas referencing a whole column ignore values in Header and Footer rows, making it possible to place the formulas below where they are.

A7: =SUM(A)

E7: =SUM(E)

Regards,

Barry

However, that said on the iPad it doesn't seem as easy as on mac.

Hi Tim,

Glad it worked out. I agree with you that setting up most documents is easier on the Mac. Where the iPad version really shines is dynamic display of results; it can be far more effective for display of results than printing static reports to paper. And the iPad (and iPhone) versions are efficient at data entry, particularly if you make use of features like Pop-Up Menu data format. Also, on the iPad you also have "forms" for data entry. There's no equivalent on the Mac for that.

The two versions, used together, can enhance productivity is significant ways.

SG

I would like to modify those amounts in that 2 columns with adding certain

Percent like 5% for example. Is ther option for it to calculate and change all those amounts with the same percentage without going one by one ?

Hi adriantoth,

The basic formula would be original value x (1 + percentage increase). So if the value is in, say B2, and you want to increase that by 5% and show the result in cell C2, then in C2 you would enter a formula like this:

=B2*(1+.05) OR you could enter =B2*(1+5%)

Once you've got the formula working in one cell, you would then "fill" the formula down to the cells below it using the techniques described upthread.

SG

Hi SG,

Thank you for your replying,

I try to do so as you write it but unfortunately I still don't get the result:

as we go as your sample is the value is in B2 to increase that by 5% then I type this into C2 cell:

=B2*(1+5%) then I tap on the "green tick" icon for result, but I still see the same formula only in C2

What I exactly typed there with no result.

Regards,

Adrian

Hi SG,

Yes it looks similar, I'm actually using ipad yes.

It seems I'm getting to understand it thanks a lot,

I just need to figure it out and practice to get this result with the additional 5% for the whole long column,

I need to do this with 2 column actually A and B, both column need to be added by that 5%, I think this only possible

Seperatly right, column by column?

Regards,

Adrian

I am trying to follow you on percentages. I would like to get percentages from a group of numbers in column A to column B using apple numbers.

I did using excel but am having trouble , in numbers, also what is the key board for division? Thanks, Ronzzzy

Hello, I am sorry that I am having such a hard time with this. I have a bunch of numbers that add up to 300 in column A. The first number in column B is 13.

I would like to get the percentage of that number, then automatically get the other numbers, and have the percentage change when I change the numbers in

column A.

Hi Adrian,

On the Mac does it look like this? (see formula lower left that appears when you select the cell with the formula)

It should look similar on the iPad too.

SG

Hi Barry,

Thank you very much it was very kind and helpful from you!

Regards,

Adrian