percent formula

[israel]

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

 

[T. Valko]

Try this:

=25*(1-14%)

A1 = 25
B1 = 14%

=A1*(1-B1)

Format as General or Number

 

[israel]

It worked thanx a million
--
smile

Try this:

=25*(1-14%)

A1 = 25
B1 = 14%

=A1*(1-B1)

Format as General or Number

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

It worked thanx a million