changing prices in multiple colunms based percentages

[MCOATES177@YAHOO]

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%,[email protected]%,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

[Toppers]

Assuming cost is in A2:

For wholesale:

=IF(A2<=99.99,A2*1.15,IF(A2<=149.99,A2*1.125,A2*1.10))

For retail:

=IF(A2<=69.99,A2*1.35,IF(A2<=89.99,A2*1.3,IF(A2<=119.99,A2*1.25,IF(A2<=199.99,A2*1.2,A2*1.15))))


"MCOATES177@YAHOO" wrote:

> 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%,[email protected]%,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
>

[Tom Ogilvy]

=if(W<=99.99,15,if(w<=149.99,.125,.10)

=if(M<=69.99,.35,if(M<=89.99,.30,if(M<=119.99,.25,if(M<=199.99,.20,.15))))

Will give you the percentage to apply. I am not sure how you intend to
apply them.

--
Regards,
Tom Ogilvy

"MCOATES177@YAHOO" <MCOATES177@[email protected]> wrote in
message news:[email protected]...
> 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%,[email protected]%,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
>