Practice / Text

Difficulty 4 of 5 · about 5 min

List invoice numbers over 50,000 in one cell

Invoice references are in A2:A8 and amounts in INR are in C2:C8. In F2, write one formula that returns every invoice reference with an amount greater than 50000, in the order they appear in the sheet, joined into one piece of text with a comma and a space between them (for example INV-A, INV-B).

Loading grid…