Forum Discussion
Solved
Formula that will have a result of 5000 or less OR a result of 0
Hello, I know how to get the first result of 5000. What I'm trying to figure out is if the two numbers I am subtracting goes below a certain threshold to make the result 0. Let's say the top numbe...
Sorry I meant to say if the variable number is between 13000 and 14499 then I want the answer to be exactly what it is. ex. 18000-14500=0, ex. 18000-12999=5000, ex. 18000-14000=4000. Is this possible to formulate? Thank you