M
mary
How can I subtract a percentage from a whole number ie: 10,000. - 90%
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sandy Mann
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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
=10000*90%
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
T
Tyro
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%
the formula in B1 could be either =A1 - A1 * 90% or =A1 * 10%
R
RichardSchollar
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
S
Sandy Mann
Ah yes of course! Mary wants 90% subtracted, DOH!
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
G
Gord Dibben
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
Same in Excel.
=10,000-(10,000*.9)
=10,000*(1-.9)
Gord Dibben MS Excel MVP