Excel Formula

[Donne]

I am trying to create a formula that would allow me to
increase the retail price on merchandise by avg. price
range.

I have a list of skus in Column A and the avg retail
price in Column B. I have a table under a different tab
that lists the markup by price range.

Example. I want to markup products that retail from $500
to $999 by 10%. I want to markup products from $1,000 to
$2,000 by 8%.

Any suggestions on the best way to do this.

Your help is appreciated.

Thanks,

Donne

 

[Norman Harker]

Hi Donne!

Try:

=IF(AND(A1>=500,A1<1000),A1*(1+10%),IF(AND(A1>=1000,A1<2000),A1*(1+8%)
,A1))

I've made assumptions that prices <500 are unchanged as are prices

=2000

If you have a whole range of different escalations, you'd be better
off putting them in a VLOOKUP table.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Donne]

Thanks,

I sent you an email on the VLookup.

Donne