Forum Discussion
if value is between
- Anonymous7 years ago
Can anyone please help me?
Hi,
I created one more table with unique data in it.
But I still cannot make the data "loop".
For example I have some product (computer programme f.e.) and it has not been used 24/7 but only 8 hrs. And the payment is only for these 8 hours.
And there is a pricing list that depends on amount of product consumed, f.e. it the product is consumed 0-5 then price is 0.003. If product is consumed 5-10, then price is 0.004. And it is in the table marked as Minimal value.
What I need is to see the pricing client gets, if he has used certain amount of product.
https://www.dropbox.com/s/ifalsxwpqtn967i/sample.xlsx?dl=0 in this sample you can see that I have different products, but I cannot link the price to them, as there are different amounts of use.
And I write a formula IF bigger than 0, "price", IF bigger 5, "price".. I think I will have to rewrite code in case when new prices / minimal values will come in! IS it possible to create some kind of indexing and then set the price?
Will wait for your help. Best, Ani
Can anyone please help me?