| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing prices in multiple colunms based percentages
I HAVE A PRICE LIST WITH THREE PRICE COLUMNS (COST,WHOLESALE & RETAIL)
I NEED A FORMULA FOR MARKING UP MY COST PRICES BASED ON PERCENTAGES FOR WHOLESALE & RETAIL. HERE'S THE WRINKLE THE PERCENTAGES ARE BASED ON THE THE COST PRICE EXAMPLE: -UP@10% / -UP@15% SO THE FIRST ONE I TRIED: SUMIF=(IF((M<69.99)+(M*1.35),W)) OR SUMIF=(IF((M<69.95)+(M+1+35%)W)) AS YOU CAN SEE I'M LOST I THINK IF I CAN GET THE FORMULA RIGHT I CAN SELECT A PORTION OF A COLUMN AND APPLY THE FORMULA JUST CHANGING VALUES FOR RETAIL ECT |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching data in multiple colunms | Excel Discussion (Misc queries) | |||
| Changing numbers/percentages to letter grades | Excel Worksheet Functions | |||
| Changing Y Axis Scale with percentages (Line Graph) | Charts and Charting in Excel | |||
| update prices in inventory based on downloaded price list?? | Excel Worksheet Functions | |||
| Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
Threaded Mode
