Originally Posted by
6StringJazzer
What is a certificate?
You gave a bunch of specific examples, which are very confusing. (What does "something is wrong" mean? Why is something wrong just because the fuel level is 31,000 litres on January 27? What does "fuel level is 29" mean--29,000 litres? Why would you give a customer a certificate for 30,000 if they have 29,000 or less?) But you have not given us a set of rules to determine when a certificate should be printed.
The fact that you said twice that it's complicated suggests that you may not understand the business problem well enough yourself yet to explain what you need. The first thing is to explain what you are trying to do, and how you would do it if you didn't have Excel. Then we can explain how to do it in Excel.
Bookmarks