percent formula
 

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

percent formula
 

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

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

percent formula
 

You're welcome!

--
Biff
Microsoft Excel MVP


"israel" wrote in message
...
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