Forum Discussion
keao46
Jan 03, 2023Copper Contributor
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...
- Jan 03, 2023
keao46
Jan 03, 2023Copper Contributor
thank you sir
PeterBartholomew1
Jan 03, 2023Silver Contributor
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)
- keao46Jan 03, 2023Copper ContributorHi,
I used the LET fx that you posted and I had to tweak it a bit but it looks like it is returning what I want it to do.
=LET(diff,L3-H22, IF(diff<(L3-O3+0.01), 0, diff))
L3= 18379
O3= 14703.20
It is doing exactly what I wanted it to do. I even modified it so that if O3 or L3 changes over time then the formula will still work.
Thanks again sir- keao46Jan 03, 2023Copper ContributorSo sorry. I would like the maximum return to be 5000 as well
Is that possible?
18000-14999=5000 max