Thread: percent formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Israel Israel is offline
external usenet poster
 
Posts: 47
Default percent formula

It worked thanx a million
--
smile


"T. Valko" wrote:

Try this:

=25*(1-14%)

A1 = 25
B1 = 14%

=A1*(1-B1)

Format as General or Number

--
Biff
Microsoft Excel MVP


"israel" wrote in message
...
Anyone please!

How do I write a formula that gives me the total after deducting %.
Example if I have $25 and I need to deduct 14% and I need to show the
total
which
would be 21.50

--
smile