Pricing Table

[xxtotalxx]

Hey all, new to the forum and new to Excel. This forum came highly recommended so I was hoping I could get some help here because I can't seem to find what I'm looking for in the Excel help files.

Basically I am trying to put together a worksheet to make quotes for my customers. I have a few different cells that are working together to make a total cost, that part was easy enough to do. The problem I'm having is making a cost, markup, total cell.

I want to be able to put my cost into a cell and have the next cell calculate my cusomter's cost via a markup. My mark up table looks like this:

$0.00 to $0.49 = x6
$0.50 to $0.99 = x5.75
$1.00 to $1.49 = x5.5
$1.50 to $1.99 = x5.25
$2.00 to $2.49 = x5
$2.50 to $2.99 = x4.75
$3.00 to $3.99 = x4.5
$4.00 to $4.99 = x4.375
$5.00 to $5.99 = x4.25
$6.00 to $6.99 = x4.125

So if my cost is $1.75 my customer would be paying $9.19 (1.75x5.25=9.1875 rounded up to $9.19). I hope this makes sense. Any help that could be provided would be outstanding and much appreciated.

[ConneXionLost]

Hi xxtotalxx,

Try this:

Please Login or Register  to view this content.

Cheers,

[xxtotalxx]

Wow. Completely solved. You are the man! Thank you so much!