Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
How can I subtract a percentage from a whole number ie: 10,000. - 90%
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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% |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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% |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|