Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 03, 2021 12:38 PM
Hello!
I have a formula to count how many workdays are left between a data and “today” and when the reference data is “after today”, the output returns a negative number (as it should).
I am looking for a way to get my formula to only return “0” when that situation occurs. I haven’t figured out the nested if statement logic to make it work. Does anyone have a solution to this?
Thank you!
Solved! Go to Solution.
Feb 03, 2021 01:53 PM
Without seeing your actual formula, sounds like you could just do the following:
MAX(0, *whatever your formula currently is*)
Feb 03, 2021 01:53 PM
Without seeing your actual formula, sounds like you could just do the following:
MAX(0, *whatever your formula currently is*)
Feb 04, 2021 05:07 AM
Yes, that works. Thank you!
Jul 24, 2024 12:39 PM - edited Jul 24, 2024 12:39 PM
This worked for me too - I had a weird situation where I was subtracting to find the remaining % and some (but not all) results were showing up as -0% - this extra nested MAX worked like a charm.
So...THANKS Kamille!