I mostly drink pure but there are a few that water does enhance the flavour.
Any excel wizards here?
I'm trying to do this:
In column A I keep scores.
in column B I have ranges to notify me to go up. (like 50, 250, 850)
in column C I have ranges to go down. (like 30, 190, 710)
In coumn D I have what I should be at. (0.25, 1, 3)
Now the hard part is this, if I have been above 50 and I'm on 1 I can keep beeing on 1 till I dip under 30. The going up and going down works like it should but the ranges in between from 50-30 gives me the lower value of 0.25 while it should be 1.