Hello everyone
I have the formula below that works for the most part, except if the value is empty, it returns "75+" and I'm not sure why. Everything else works fine.
Thoughts?
HTML Code:
Hello everyone
I have the formula below that works for the most part, except if the value is empty, it returns "75+" and I'm not sure why. Everything else works fine.
Thoughts?
HTML Code:
Last edited by AccountingJ; 02-04-2019 at 03:51 PM.
When J2 is empty, I get 0-15.
I would do it like this. IMHO it's more readable and easier to update.
Formula:Please Login or Register to view this content.
A lot easier to update for sure! Thank you Jazzer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks