If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
percentage formula
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 |
#2
|
|||
|
|||
percentage formula
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 |
#3
|
|||
|
|||
percentage formula
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 |
#4
|
|||
|
|||
percentage formula
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 |
Thread Tools | |
Display Modes | |
|
|