Forum Discussion
Solved
Creazione formula matematica/mathematical formula creation
Di seguito scrivo il problema da cui creare una formula: -Se le spese sono inferiori a €3000, il conduttore paga le spese in relazione al consumo, fino ad un importo massimo di €1500. Il resto delle...
Try this then.
What about the max amount of 1500? Does that depend on the liter price too?
Does this do what you want?
- HansVogelaar
it seems perfect, but excuse my ignorance, by increasing the price per litre, we make it double €2.10, is it normal for the values 1 and 2 to halve? example, if fuel costs €2.10, it takes half the number of liters to reach the reference figure, so shouldn't the reference figures double? thank you alwaysTry this then.
- HansVogelaar
perfect, thank you so much, you are a genius, I respect you so much
- it seems perfect, but excuse my ignorance, by increasing the price per litre, we make it double €2.10, is it normal for the values 1 and 2 to halve? example, if fuel costs €2.10, it takes half the number of liters to reach the reference figure, so shouldn't the reference figures double? thank you always
- I'm checking now, I hadn't seen your file
- yes, because the €1500 changes based on the €3000, I think it is always 50% there
