Related Article

What’s new in Numbers for Mac

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: How do I subtract a dollar amount in a cell from a percentage?

How do I subtract a percentage from a dollar in a cell?

iOS 7.0.3

Posted on

Reply

Dec 13, 2017 7:05 PM in response to tammiel72 In response to tammiel72

to subtract 10% from a number means that you multiple by 0.9 (which is 1 - 0.1)


so if cell A1 has the value 100

and you want to subtract 10%


you can multiply the value in cell A1 by 0.9


in another cell type the formula:

=0.9*A1


If you want to have another cell, let's say cell B1 contain the amount to subtract then put the amount in B1

let's say 0.1


then use the formula in another cell:

=A1*(1-B1)

Dec 13, 2017 7:05 PM

Reply Helpful

Dec 13, 2017 10:38 PM in response to tammiel72 In response to tammiel72

Hi tammiel,


Wayne's first formula is the simplest.


The versions below follow your description more closely. I've used 12% only because it keeps both digits, where 10% drops the trailing zero when written as a decimal.


"How do I subtract a percentage from a dollar (amount) in a cell?"


B2 contains a dollar amount—a number, formatted as currency.

C2 contains a formula that calculates a percentage of the amount in B2, and subtracts it from the amount in B2.


C2: B2-(B2*12%)


"percent" means "per hundred"

12 percent is the same number as 12/100

Expressed as a decimal, 12/100 is 0.12

so the same formula can be written this way:


C2: B2-(B2*0.12)


Using the same percentage, both of Wayne's formulas and both versions of mine will give the same results.



Regards,

Barry

Dec 13, 2017 10:38 PM

Reply Helpful
User profile for user: tammiel72

Question: How do I subtract a dollar amount in a cell from a percentage?