Markup Calculator

[HVACPartsGUy]

I'm looking for some help with creating a formula to return the cost of on part when it is between to values.
I have attached a photo of what I was given. Below is a sample of the data.

Parts Multiplier.png

If our cost of the part is with the values of column A and C the our cost would be multiplied by the value in column D. I want one cell to provide the customers cost with the markup.

A	B	C	D
0.00	to	0.49	6
1.00	to	1.49	5.75
1.50	to	1.99	5.5

[Crooza]

If you use cell H2 to put the price of any part you want to check and then use this formula which can be be placed in H3 (or wherever else you like) to calculate the marked up price

Please Login or Register  to view this content.

[HVACPartsGUy]

I tried using the formula you provided but it returned the same value I entered into the cell.

I was able to create this formula, but have not been able to go any further with it.

I need this same type if formula to apply to all cells and return the value into cell H3.

I also need a roundup function in the formula.

I uploaded an updated file.

=IF(H2<=0.49,H2*D3)

[Crooza]

I'd send you a copy of the file but you seem to have removed it

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[HVACPartsGUy]

I'm not sure what happened to the attachment. I attached an updated attachment yesterday, but it seems to have disappeared.

Thank you for your help.

[Crooza]

Here's your file back with my formula in it (see J2)

[HVACPartsGUy]

Thank you that worked.