Nigel Thomson

18-08-2004, 12:24 PM

greetings all

I have a price list, for a variety of products (4500ish) and I need to do the markups, and need a bit of help working out the formulae (I haven't really used Excel at all) ,

for example

if the price in col 2 is <= $0.49 then the mark up is a factor of 2,

if the price in col 2 is <= $0.99 and >=$0.50 then the mark up is a factor of 1.5,

if the price in col 2 is <= $1.49 and >=$1.00 then the mark up is a factor of 1

I hope that explains what I am trying to do,

Thanks Nigel

(those aren't the real markup figures of course)

I have a price list, for a variety of products (4500ish) and I need to do the markups, and need a bit of help working out the formulae (I haven't really used Excel at all) ,

for example

if the price in col 2 is <= $0.49 then the mark up is a factor of 2,

if the price in col 2 is <= $0.99 and >=$0.50 then the mark up is a factor of 1.5,

if the price in col 2 is <= $1.49 and >=$1.00 then the mark up is a factor of 1

I hope that explains what I am trying to do,

Thanks Nigel

(those aren't the real markup figures of course)