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: WHOLESALE-0-99.99@15%,100.00-149.99@12.5%,150.00-UP@10% /
RETAIL-0-69.99@35%,70.00-89.99@30%,90.00-119.99@25%,120.00-199.99@20%,200.00-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