Quote Originally Posted by NBVC View Post
Sorry I am still not following... can you be specific, name cells, steps with specific examples...etc to make the point clear.
Going from left to right in the blank row:

Enter the text item of the purchased item; enter the date; now the hard part. I'm forced to enter an arbitrary initial price to the item in question because the sales tax rate is hard coded to a certain rate. This is problematic because if the sales receipt shows a total amount but gives no sales tax...I have to fiddle with the initial cost of the item to match the final total amout listed on the receipt. Since it doesn't give me the sales tax rate...I have to "guess" the cost of the initial price even if it doesn't match what it says on the receipt.

For example...suppose the item cost 5.00 dollars. But since the receipt doesn't show the sales tax...I have to play with the item cost to match the sales receipt listing the final item price I paid for the purchase. So this means since the sales tax rate I have listed is static...I'm forced to adjust the initial price of the item to match the cost listed on the receipt that it gives for the total. So, if the final cost including the mysteriously not mentioned sales tax rate on the slip showed I paid 5.42 I have no way of knowing what the sales tax rate should be to account for that item total. This means I need to fool around with the 5.00 initial cost to make the formula match the final tally for the item...which in this hypothetical example is 5.42.