gleichmang
New Member
- Joined
- Dec 28, 2011
- Messages
- 15
My formula is as follows:
=IF(OR(P17="A - Svcbl(w/o Qual)",P17=""),(AM17+365),(AM17+10))
and I want to add the below to the formula.
=IF(TODAY()-RC[-2]>=91,""Over or equalto 91 days"",""Less than 91 days"")
How do I nest these 2 formulas together
Bottom line.... I have a value in column P. Depending on that value, it will calculate a date contained in column AM. Once that date has been calculated, then I need the cell to display the second formula I have listed above
=IF(OR(P17="A - Svcbl(w/o Qual)",P17=""),(AM17+365),(AM17+10))
and I want to add the below to the formula.
=IF(TODAY()-RC[-2]>=91,""Over or equalto 91 days"",""Less than 91 days"")
How do I nest these 2 formulas together
Bottom line.... I have a value in column P. Depending on that value, it will calculate a date contained in column AM. Once that date has been calculated, then I need the cell to display the second formula I have listed above