View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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