Need help please.
I am trying to make a pricing markup sheet, where if the price is between (for example) between 1 cent to $1 the cost of the item would be multiplied by a certain percent(3.7), but if the cost of the item was more, like between $21.01 and $22 it would be multiplied by a different % (2.65) and so on...
I know my formula should say something like Cell XY in Column C (cost of item) compare to column A & B on sheet 2, if cost of item in cell XY is >= column A but <= column B then multiply by the correct cell in column C
How do I write this so it will work? Here is a portion of my pricing guide lines I'm making for selling parts.
I have attached my parts worksheet and it includes Sheet 1 and 2. Sheet 1 for my prices and sheet 2 for my look up tables. Can any one help me write a forumula to do this, or can it be done. Please any help would be greatly appreciated.
Thanks Aranon
I am trying to make a pricing markup sheet, where if the price is between (for example) between 1 cent to $1 the cost of the item would be multiplied by a certain percent(3.7), but if the cost of the item was more, like between $21.01 and $22 it would be multiplied by a different % (2.65) and so on...
I know my formula should say something like Cell XY in Column C (cost of item) compare to column A & B on sheet 2, if cost of item in cell XY is >= column A but <= column B then multiply by the correct cell in column C
How do I write this so it will work? Here is a portion of my pricing guide lines I'm making for selling parts.
I have attached my parts worksheet and it includes Sheet 1 and 2. Sheet 1 for my prices and sheet 2 for my look up tables. Can any one help me write a forumula to do this, or can it be done. Please any help would be greatly appreciated.
Thanks Aranon
