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 number is 18000 and the variable number is <14500 then I want the solution to be 0. However, if the answer is between 13000 and 14499 then I want the actual number to be the solution.
Is this possible to formulate?
Thank you in advance for your time.
Chad
6 Replies
- thank you sir
Have you changed the problem? Your example seem to conform more to
In that case, a simpler formula would do
= IF(variable#<bound, top - variable#, 0)
- 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
