percent formula

israel · Dec 18, 2008

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 · Dec 18, 2008

Try this:

=25*(1-14%)

A1 = 25
B1 = 14%

=A1*(1-B1)

Format as General or Number

israel · Dec 18, 2008

It worked thanx a million
--
smile

T. Valko said:
Try this:

=25*(1-14%)

A1 = 25
B1 = 14%

=A1*(1-B1)

Format as General or Number

T. Valko · Dec 18, 2008

You're welcome!

--
Biff
Microsoft Excel MVP

israel said:
It worked thanx a million