ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need help with formula (https://www.excelbanter.com/excel-discussion-misc-queries/155496-need-help-formula.html)

VDan

Need help with formula
 
I need a formula that will subtract 10% of a number.

Gary''s Student

Need help with formula
 
=.9*A1
--
Gary''s Student - gsnu200739


"VDan" wrote:

I need a formula that will subtract 10% of a number.


Elkar

Need help with formula
 
To subtract 10%, you just multiply by 90% or 0.9. Let's say your number is
in cell A1.

=A1*.9

or if its easier to think of it in terms of subtraction, then you could also
use:

=A1-(A1*.1)

HTH,
Elkar


"VDan" wrote:

I need a formula that will subtract 10% of a number.



All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com