can someone give me a formula to dicount by percent.
Example:

A1 B1 C1
£50. -33% £33.50
£95. -27% £69.35 and so on down the sheet.

As you can see i would like to put in all different % in column B & have a
cost price
in column C.
Excel 2007

Please look at the four answers on your previous post.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"David Wilson" wrote:

can someone give me a formula to dicount by percent.
Example:

A1 B1 C1
£50. -33% £33.50
£95. -27% £69.35 and so on down the sheet.

As you can see i would like to put in all different % in column B & have a
cost price
in column C.
Excel 2007

What if I wanted to find the percentage of mortgage payment to total monthly
income, if the mortgage payment was $1000 and the total monthly income was
$4200?

"David Wilson" wrote:

can someone give me a formula to dicount by percent.
Example:

A1 B1 C1
£50. -33% £33.50
£95. -27% £69.35 and so on down the sheet.

As you can see i would like to put in all different % in column B & have a
cost price
in column C.
Excel 2007

Divide the payment by the income:

=1000/4200

Format as Percentage

--
Biff
Microsoft Excel MVP


"Lisa Wilburn" <Lisa wrote in message
...
What if I wanted to find the percentage of mortgage payment to total
monthly
income, if the mortgage payment was $1000 and the total monthly income was
$4200?

"David Wilson" wrote:

can someone give me a formula to dicount by percent.
Example:

A1 B1 C1
£50. -33% £33.50
£95. -27% £69.35 and so on down the sheet.

As you can see i would like to put in all different % in column B & have
a
cost price
in column C.
Excel 2007