Oct 29 2020 01:17 PM
Hello!
Trying to add another rule to this formula:
=IF(TODAY()-B2<=30,"0-30 days",IF(TODAY()-B2<=60,"31-60 days",IF(TODAY()-B2<=90,"61-90 days","over 90 days")))
The additional string would be to basically cancel/dont calculate if in cell K2 the word : "paid" or "applied" or "void" is there.
Oct 29 2020 02:33 PM
SolutionLike this:
=IF(OR(K2={"applied","paid","void"}),"",LOOKUP(TODAY()-B2,{-1000;31;61;91},{"0-30 days","31-60 days","61-90 days","over 90 days"}))
Oct 29 2020 02:33 PM
SolutionLike this:
=IF(OR(K2={"applied","paid","void"}),"",LOOKUP(TODAY()-B2,{-1000;31;61;91},{"0-30 days","31-60 days","61-90 days","over 90 days"}))