Discussion Re: How to set up an aging formula that only runs if the item is open and not closed in Excel
https://techcommunity.microsoft.com/t5/excel/how-to-set-up-an-aging-formula-that-only-runs-if-the-item-is/m-p/1513201#M68149
<P><LI-USER uid="685691"></LI-USER> </P>
<P>Carter, perhaps you may share small sample file. It's not clear what do you mean, e.g. <SPAN><STRONG>while C stands for closed</STRONG> - what is C, how Excel knows it's closed or not, etc.</SPAN></P>Thu, 09 Jul 2020 22:45:13 GMTSergei Baklan2020-07-09T22:45:13ZHow to set up an aging formula that only runs if the item is open and not closed
https://techcommunity.microsoft.com/t5/excel/how-to-set-up-an-aging-formula-that-only-runs-if-the-item-is/m-p/1512176#M68107
<P>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 case, only if it is open. I have the dates column, status column, and a aging column that I will use for the aging output. I have researched this for a solid hour and come up with nothing that fits my situation. I am fairly new to Excel and still learning as I go. If anyone has some suggestions, it would be greatly appreciated.</P><P> </P><P>Thanks for y'alls help!</P><P>Carter</P>Thu, 09 Jul 2020 15:51:22 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-set-up-an-aging-formula-that-only-runs-if-the-item-is/m-p/1512176#M68107CarterDRH2020-07-09T15:51:22ZRe: How to set up an aging formula that only runs if the item is open and not closed
https://techcommunity.microsoft.com/t5/excel/how-to-set-up-an-aging-formula-that-only-runs-if-the-item-is/m-p/1513201#M68149
<P><LI-USER uid="685691"></LI-USER> </P>
<P>Carter, perhaps you may share small sample file. It's not clear what do you mean, e.g. <SPAN><STRONG>while C stands for closed</STRONG> - what is C, how Excel knows it's closed or not, etc.</SPAN></P>Thu, 09 Jul 2020 22:45:13 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-set-up-an-aging-formula-that-only-runs-if-the-item-is/m-p/1513201#M68149Sergei Baklan2020-07-09T22:45:13Z