help with formula
 

How can I subtract a percentage from a whole number ie: 10,000. - 90%

help with formula
 

Wouldn't simply multiplting by the percentage do what you want?

=10000*90%

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"mary" wrote in message
...
How can I subtract a percentage from a whole number ie: 10,000. - 90%

help with formula
 

I assume you mean: 10,000 - 90% of 10,000. If so, then if 10,000 is in A1,
the formula in B1 could be either =A1 - A1 * 90% or =A1 * 10%

"mary" wrote in message
...
How can I subtract a percentage from a whole number ie: 10,000. - 90%

help with formula
 

On Dec 29, 7:22 pm, mary wrote:
How can I subtract a percentage from a whole number ie: 10,000. - 90%

Hi Mary

Perhaps with your number in A1 then conceptually speaking I think the
following is easiest:

=A1*(100%-90%)

Richard

help with formula
 

Ah yes of course! Mary wants 90% subtracted, DOH!

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"RichardSchollar" wrote in message
...
On Dec 29, 7:22 pm, mary wrote:
How can I subtract a percentage from a whole number ie: 10,000. - 90%

Hi Mary

Perhaps with your number in A1 then conceptually speaking I think the
following is easiest:

=A1*(100%-90%)

Richard

help with formula
 

How would you do it with a pencil and paper or a calculator?

Same in Excel.

=10,000-(10,000*.9)

=10,000*(1-.9)



Gord Dibben MS Excel MVP


On Sat, 29 Dec 2007 11:22:01 -0800, mary wrote:

How can I subtract a percentage from a whole number ie: 10,000. - 90%