Forum Discussion
if value is between
- Anonymous7 years ago
Can anyone please help me?
Hi Anonymous ,
I still have a little confused about your senario.
Do you want to create the relationship for your tables?
If it is, please share your data sample and your desired output so that I could have a test on it.
Best Regards,
Cherry
- Anonymous7 years agoNot applicable
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
- Anonymous7 years agoNot applicable
Can anyone please help me?