| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percent and dollar formula don't mix
Hello in Excel 2003 my formula is =(V10-U10/X10)/V10) this means
current list price - fixed price /by units sold / by current list price. example current list price is $257,506.00 fixed price is $225,000.00 units sold is 1 so the discount is 12.62% my problem is if there is more than 1 unit sold I get the wrong answer also when the fixed price is not a dollar amount but a percent example 10% then my answer is also wrong. How do I correct his thanks a million. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
| Percent Formula | Excel Discussion (Misc queries) | |||
| How do I let a percent formula = 0? | Excel Discussion (Misc queries) | |||
| How do I let a percent formula = 0? | Excel Discussion (Misc queries) | |||
| Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
Threaded Mode
