Advanced Formula to calculate if a certain action is required using 'IF' formula

Welcome to the forum chipsgro,

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

If I understand correctly then there could be a table of receipt numbers and locations somewhere in the workbook. I placed such a table on sheet 2. Notice that it is sorted (least to greatest) by the first receipt number associated with each location.
The formulas (shown in C8:D11) are as follows:
For Material Billing Needed: =IF(INDEX(Sheet1!C$3:C$8,MATCH(A8,Sheet1!A$3:A$8,1))=B8,"no","yes")
For Delivery Billing Needed: =IF(A8>=100000,"no","yes")
If these formulas don't continue to yield the expected results, I would suggest uploading more samples in columns A and B along with expected outcomes (and explanations).
Let us know if you have any questions.

if B2 is b/t 9501 and 12000 then NO

It isn't possible for a cell to contain a single value that is both <=9500 and >=12001
It is possible for a cell to contain a value that is both >9500 and < 12001
To get that you could write: =IF(AND(B2>9500,B2< 12001),"no","yes")
Similarly: =IF(OR(B2<=9500,B2>=12001),"yes","no")
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link in the ribbon above your first post. I hope that you have a blessed day.