Feb 21 2019 08:44 AM
Hello everyone,
I am trying to create several conditions for an Excel I am working on but I am struggling to make them work.
Could anyone assist me with this? Thank you
Feb 21 2019 10:42 AM
Try what I did, in attachement.
Tell me if that's what you need and if so I'll explain something you need (in case you need).
Feb 21 2019 11:12 AM
I believe that this will work but is there a way to program it into the conditional formatting instead of setting it up as a function tied to a cell? I am creating a template that will be used monthly with different data.
Feb 22 2019 02:32 PM
I messed around with the formula a bit because I wasn't able to make it work at first for my document. However now when I try to use it, it will only work for items that are tier 3. Do you see something that I did wrong?
=IF(3,IF(AND($J2=3,$H2<TODAY()-730),"Past Due","Current"),IF(AND($J2=2,$H2<TODAY()-360),"Past Due","Current") IF(AND($J2=1,$H2<TODAY()-360),"Past Due","Current"))
Thank you
Feb 23 2019 12:49 AM
Feb 23 2019 02:49 PM
The initial part makes me uncomfortable:
=IF(3,
check it out, I think was the same as the other part, like:
=IF(AND($J2=3
then fix brackets ;)