Hi There,
I have posted this query in another context on this page. However, if this is possible using the IF function, it would be ideal for my use.
The formula I'm working on is:
=IF(ISBLANK(A1);" ";(IF(TODAY()>A1+13;"Date Due";(IF(B1="Completed Task";"Check Case Progress";" ")))))
The issue is that I am trying to check two different cells references and that's creating too many arguments for the formula. The formula is in a column that shows me alerts for cases on each row. I would actually like to add more checks in this column but I guess the way to do that will be a VBA.
Any suggestions on the above? Is there better way of doing this?
Thank you.
I have posted this query in another context on this page. However, if this is possible using the IF function, it would be ideal for my use.
The formula I'm working on is:
=IF(ISBLANK(A1);" ";(IF(TODAY()>A1+13;"Date Due";(IF(B1="Completed Task";"Check Case Progress";" ")))))
The issue is that I am trying to check two different cells references and that's creating too many arguments for the formula. The formula is in a column that shows me alerts for cases on each row. I would actually like to add more checks in this column but I guess the way to do that will be a VBA.
Any suggestions on the above? Is there better way of doing this?
Thank you.