Find when a value doesn't exist OR if it net value equals 0
I have a spreadsheet containing Sales Orders that are made up of part numbers for new systems purchased and part numbers for the education purchased to train that new system. I want to be able to identify those Sales Orders where there is no education included. There are 2 scenarios when this can occur:
1). If there was no Education included in the order at all. In which case there are no education part numbers showing up against that Sales Order.
2). If Education was originally included but was then removed. This is represented as 2 separate rows in the spreadsheet. The first shows a positive value and the second shows a negative value with the net result equaling zero.
I want to be able to create a field in the spreadsheet that can identify these 2 scenarios and fill in the value "No Education Included" and for all other use the field "Education Include".
Below I have included 2 tables. The first demonstrates an example of what I have now and the second is what I am trying to achieve. Please note that the Part Number names vary greatly and the ones included in the table below are just examples. Any help would be greatly appreciated.