Before the table is loaded into the accounting system, it needs to be checked. A row has an error if the price is missing or the quantity is less than 1.
In D2:D9, show "Error" for such rows and "OK" for the rest.
Before the table is loaded into the accounting system, it needs to be checked. A row has an error if the price is missing or the quantity is less than 1.
In D2:D9, show "Error" for such rows and "OK" for the rest.