Percentages in Numbers

Q1:

percentage is the part divided by the whole times 100.

so retail% of sales is 100 x (retail/(treatments + retail))

therefore:

M2=100*L2/G2

OR

M2=L2/G2%

Q2:

for the totals you can sum each column (G and L) in a row at the bottom, then perform the same computation on the corresponding cells:

Here I show 14 days where I sum column G (in row 16) and the retails in column L.

G16=SUM(G1:G15)

select G16 and copy, then select L16 and paste.

Then select the formula in M2 and paste in M16

Leave out the x100 in the formula. 0.40 = 40% whereas 0.40*100 = 40 = 4,000%

In addition to Bad Units response and my previous response you can perform the math operation part/whole (which necessarily results in a number between 0 and 1. Then you can format that as a "%" using the cell formatting tool:

Just the ratio:

Showing the formatting tool:

Formatted as %

Hi Louise,

Perhaps an example will help.

What changes is NOT the value, but the way that the value is displayed.

If you divide three by four and express the result as a decimal fraction, the result is 0.75.

If you express the same result as a percentage, the result is 75%, or literally, 75 out of 100.

Numbers does the same thing.

If you divide three by four by entering the formula =3/4 into a cell, and leave the cell set to "automatic," the cell will display 0.75, the decimal fraction equivalent to the common fraction 3/4.

If you divide three by four by entering the formula =3/4 into a cell, and set the cell's format to "percentage," the cell will display 75% (or 75.00% in my case), the percentage equivalent to the common fraction 3/4. (Three out of four is the same proportion as seventy-five out of one hundred.)

Your example, "40" can, like any whole number, also be expressed as a fraction: 40/1, or 40÷1 (forty divided by one).

Percentages are always 'out of' or 'divided by' or 'per' one hundred,

Four thousand per hundred is the same proportion as Forty per one (or Forty each).

Here's another example, different enough that it may also help.

Suppose you broke a lace for one of your favourite pair of hiking boots, and measured it to determine what length replacement you needed to buy.

Your measurement, done with a yardstick, found the lace to be (almost exactly) two yards long.

"Wow!" you said. "Six feet! That's longer than I am tall." And off to the cobbler's shop you went, to look for a replacement lace.

When you got there, you couldn't find any laces that were labeled "2 yds", nor could you find any that were labeled "6 ft" or "6'." Fortunately, though, you did remember that there are 12 inches in a foot, and you did see a single pair labeled "72 inches," so you bought those, and laced up your boots.

Did they fit? Of course they did. "Two yards," "Six feet," and "Seventy-two inches" all express the same length, just as 0.75, 75/100 and 75% (or 40, 4000/100 and 4000%) express the same quantity.

Regards,

Barry

can you show the values, and formula and results?