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
How do I subtract a percentage from a dollar in a cell?
iOS 7.0.3
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)
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
How do I subtract a dollar amount in a cell from a percentage?