excel formula

  • Thread starter Thread starter blondette
  • Start date Start date
B

blondette

I'm trying to figure out a formula to subtract a percenage
from a percentage. For example: =sum(f2*25%-10%)
This formula as I have it doesn't work. If I remove the
last % sign it will subtract 10 from the 25%. Can anyone
tell me how to subtract 10% from the 25%? I'd appreciate
any help!! Thanks
 
Hi Blondette!

=F2*25%*90%

Or in general terms:

=F2*25%*(1-10%)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
One way:

I'm assuming that you're trying to subtract 10% of the result of F2*25%.
If that's the case,

=F2 * 25% * (1 - 10%)

or

=F2 * 25% * 90%

will get you what you need (no need for the SUM() function).


If instead you're trying to multiply F2 by (25% - 10%) or 15%, then you
can use

=F2 * (25%-10%)

or

=F2 * 15%

If you're after some other formula, post back with more details.
 
Depends what you want.
1) 25% decreased by 10% then use =25%-10% (15%)
So the formula is =F2*(25%-15%) --- the SUM is not needed
2) 25% reduced by 10% of itself = 25%*(100%-15%) or 25%*85% = 21.25%
So the formula is =F2*25%*(100%-15%)

If you treat percentages as fractions (25% is 0.25) it is so much clearer.
You want 0.25*(1-0.15)
 
Back
Top