Supposing that Invoice is a table containg detailed information about invoices, what does this formula return?
=FILTER(Invoices,(LEFT(Invoices[customer])="x")*(Invoices[region]="east")*NOT(MONTH(Invoices[date])=4))

Question

Answer

An invoice with a customer name starting with x and in region east and not from April

Answer

An invoice with a customer name starting with x or in region east or not from April

Answer

A list of all invoices with a customer name starting with x and in region east and not from April

Answer

A list of all invoices with a customer name starting with x or in region east or not from April

Crowdly

Supposing that Invoice is a table containg detailed information about invoices, ...

Want instant access to all verified answers on moodle.essec.fr?