Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Percentages in Excel
Hi
I have three columns as below Unit Price ABC Company Price EFG Company Price Not Known 40% discount 30% Discount Not Known 20% discount 30% Discount I am getting a little confused because there seems to be in the Excel help file different ways to calculate, and I keep getting different answers! I need to work out firstly what the Unit price is, and I need to work it out from the discount given to EFG Company (ie 30%). From that, once I work out the Unit Price I can work out what I will be selling my goods at to ABC Company. My problem is, I have never been good with maths and have been told that just putting on 30% will not give me a correct answer, I should use a decimal point ie 0.50 (which I think is 50%) or 0.70 for 30%. Can someone help me here as I have messed about with this all morning and got nowhere fast Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Percentages In Excel | Excel Discussion (Misc queries) | |||
calculating percentages | Excel Worksheet Functions | |||
Calculating percentages | Excel Discussion (Misc queries) | |||
calculating percentages | Excel Discussion (Misc queries) | |||
Calculating percentages | Excel Worksheet Functions |