Forum Discussion
How to set up an aging formula that only runs if the item is open and not closed
I am attempting to create a formula that will only run if one of the cells is labeled O. O stands for open while C stands for closed. I am wanting to setup a formula that will show the age of an open...
Carter, perhaps you may share small sample file. It's not clear what do you mean, e.g. while C stands for closed - what is C, how Excel knows it's closed or not, etc.