Formula help

[SS]

Looking to discount an amount by 10%
Using the formula below I get 309 to discount to £308, it should be around
£278,
Whats wrong with formula, thanks

=SUM(K24:K27)-(10%)

 

[Don Leonard]

=SUM(K24:K27)*(90%)

 

[Steve]

| =SUM(K24:K27)*(90%)
|
| | > Looking to discount an amount by 10%
| > Using the formula below I get 309 to discount to £308, it should
be around
| > £278,
| > Whats wrong with formula, thanks
| >
| > =SUM(K24:K27)-(10%)
| >
|

Or:

=SUM(K24:K27)-((SUM(K24:K27)*.10)

--
Steve Spence
Independent AMSOIL Dealer
AMSOIL - The "Once A Year" Oil Change
Unemployed Car Guy - Trying To Earn A Living
35 Years of G.M. Parts Experience
URL: http://synthetic-oil-tech.com/1690163
Email: (e-mail address removed)
|