Hi there,
I have a set of data which changes daily. Column B = Yesterday's values in %, Column C = today's values in %. If the number in column C crosses a threshold then I would like a prompt of some sort to say so. Initial thoughts are that this could be an IF statement which returns "Check" for example.
The thresholds are 20%, 30%, 40% and 50% and should trigger when today's value (column B) goes over or under this value. For example, yesterday was 19.1% and today it is 20.5% would return a prompt notifying the user. However if it goes from 33% to 38% then no prompt is required as it has remained within the threshold. For example:
<tbody>
</tbody>
At the moment I have the beginnings of a very long IF statement but there must be a simpler/more concise way to do this? Right?
Thanks!
I have a set of data which changes daily. Column B = Yesterday's values in %, Column C = today's values in %. If the number in column C crosses a threshold then I would like a prompt of some sort to say so. Initial thoughts are that this could be an IF statement which returns "Check" for example.
The thresholds are 20%, 30%, 40% and 50% and should trigger when today's value (column B) goes over or under this value. For example, yesterday was 19.1% and today it is 20.5% would return a prompt notifying the user. However if it goes from 33% to 38% then no prompt is required as it has remained within the threshold. For example:
Product | Yesterday | Today | Prompt |
A | 19.1% | 20.5% | CHECK |
B | 33% | 38% | OK |
C | 28% | 19.9% | CHECK |
<tbody>
</tbody>
At the moment I have the beginnings of a very long IF statement but there must be a simpler/more concise way to do this? Right?
Thanks!