Hello,
I have been checking the forum and I haven'found a solution to this question.
I cut cardboards to the client requests and I have to calculate a price. Here is the example:
Cardboards (cm)
40x30 -> 3,5€
40x40 -> 4€
60x40 -> 5€
60x60 -> 5,5€
the client can request a 57x15 cardboard, so the price is 5€ because I have to sell the 60x40 cardboard. If they ask to me a 57x57 cardboard, I have to sell the 60x60 cardboard that is 5,5€.
I can not construct a formula to obtain the price, even with vlookup, match, index, and so on. Is there a formula to be applied or I have to create a macro?
Thanks in advance.
I have been checking the forum and I haven'found a solution to this question.
I cut cardboards to the client requests and I have to calculate a price. Here is the example:
Cardboards (cm)
40x30 -> 3,5€
40x40 -> 4€
60x40 -> 5€
60x60 -> 5,5€
the client can request a 57x15 cardboard, so the price is 5€ because I have to sell the 60x40 cardboard. If they ask to me a 57x57 cardboard, I have to sell the 60x60 cardboard that is 5,5€.
I can not construct a formula to obtain the price, even with vlookup, match, index, and so on. Is there a formula to be applied or I have to create a macro?
Thanks in advance.