AR Report

[850992]

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.

[#2 · Accepted solution]

@850992 

Like 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"}))

[#3]

Thank you!