MS Excel Examples: Net Price
 Introduction
 This small example shows how to perform a simple operation of calculating the amount of tax retrieved from a sale item and the net price sold. The marked price, the price presented on an item, is in currency value. It this example, it would be \$120.95 The tax rate is expressed as a percentage value. An example would be 5.75% The computer used to evaluate the price use a formula such as: Tax Amount = Marked Price / Tax Rate The net price, the actual price a customer should pay, is calculated as: Net Price = Marked Price + Tax Amount In this exercise, we will simulate such a calculation
 Practical Learning: Performing the Calculation
 Start Microsoft Excel In cell B2, type Net Price Calculation In cell B3, type Marked Price: In cell B4, type Tax Rate: In cell B5, type Tax Amount: In cell B6, type Net Price: In cell D3, type 0.00 In cell D4, type 5.75% In cell D5, type =D3*D4 In cell D6, type =D3+D5 To test the application, change the value of cell D3 and press Enter