Forum Discussion
Two Formulas, One Cell
Hi everyone. I need help please. I am trying to create an Excel spreadsheet such as follows in the attached photo. I've already successfully created formulas to calculate the aging days in the app...
Hi Tiffany,
Perhaps like
=IF((C2>1)*(D2>1), <your formula>, "")
and so on
it is applicable with my problem where i want to stop the count of aging once i put a closed date. currently i use the formula =IF(TODAY()>C8,TODAY()-C8,0) for aging.