### What is the formula for calculating the inclusive tax amount from a given amount?

Let's answer it with mathematical approach. You might required to use it in the formula or in VBA. This simplification will help you for sure. Assume few variablesX = Product's Original Amount without TaxY = Inclusive Tax Amount (i.e. you're looking)Z = Product's Amount with Tax or MRP or Included tax amount.Q = Tax %-So basic foundation of product's final amount after tax including is like,X + Y = ZNow, Y = ( Q * X ) / 100So the equation become,X + ( Q * X ) / 100 = ZNow solve the above equation to find the value of XX = ( Z * 100 ) / ( Q + 100 )And to get the value you required put this value of X back to the initial equationX + Y = Z{( Z * 100 ) / ( Q + 100 )} + Y = ZNow solve for Y,Y = ( Z * Q ) / ( Q + 100 )So put known values of Z & Q in the above equation and you will get the required value.Good day.Kamal Bharakhda