There might be other ways to do this, but I would just do it as 2 different formula fields.
What you outlined above would give you the result in your 1st formula field.
Then, in your 2nd formula field, you would evaluate whether your 1st formula field was negative or positive. If it was negative, it would result in a blank field. If it was positive, it would show you the same result.
The other way you could do it would be to wrap that entire large block of IF statements in yet another enclosing IF statement, which would essentially be evaluating the results of your large block of IF statements as the result to evaluate for the one “master surrounding IF statement”. So just put another IF statement AROUND your existing block of IF statements.
I’d like to use this simplified method, but i input what you wrote and it gave an error. Sorry, I’m a noob. I could do it either way, but I’m not even sure how to wrap the entire thing in an IF statement as suggested. Could anyone show me how that’s done on the original formula? Thanks!
It’s working, thanks! Now one last thing, how can I make it leave the cell blank if my Update Cycle cell is empty? Right now it shows whatever number is in the Days Since Update cell if that cell is empty.