medium10 pts · first answer countsexcellogical-functionsaccounting

Ageing buckets for receivables

D2 holds days overdue (=TODAY()-C2). Which formula puts each invoice into 0–30, 31–60, 61–90 or 90+ buckets?

A.=IFS(D2>30,"31-60",D2>60,"61-90",D2>90,"90+",TRUE,"0-30")B.=IF(D2<=30,"0-30",IF(D2<=60,"31-60","90+"))C.=IFS(D2<=30,"0-30",D2<=60,"31-60",D2<=90,"61-90",TRUE,"90+")D.=IFS(D2<30,"0-30",D2<60,"31-60",D2<90,"61-90")

Discussion 0

Join free to post in the discussion.

Ageing buckets for receivables

Discussion 0

Related questions