|
| 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
February 12th, 2009, 09:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
February 12th, 2009, 09:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 15th, 2009, 02:52 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 15th, 2009, 03:38 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
