I am trying to make a formula that would multiply a dollar amount with a tax percentage and add that to one field in Excel under With Tax I would also need to have that tax value in a total column.
A Food name
B Price of food item
C With Tax (This should be the taxes of the food item)
D Sum of the price of the food item and the taxes added together
Please could you give me the information that I need to make two seperate formulations