By plugging different numbers into a cell, you can quickly come up with different answers to a problem. A great example is using thePMTfunction with different interest rates and loan periods (in months) to figure out how much of a loan you can afford for a home or a car. You enter your numbers into a range of cells called a data table.
Here, the data table is the range of cells B2:D8. You can change the value in B4, the loan amount, and the monthly payments in column D automatically update. Using a 3.75% interest rate, D2 returns a monthly payment of $1,042.01 using this formula: =PMT(C2/12,$B$3,$B$4).

Price:
Price 334455.0 EUR () / Dozen
Minimum Order Quantity : 60 Dozens
Product Type : Other, Digital Thermometer
Material : ABS Plastic
Dimension (L*W*H) : 13.5 x 2.2 x 1.2 cm
Color : White
Price 1500.0 INR
Minimum Order Quantity : 60 Dozens
Product Type : Other, Cotton Bag
Material : 100% Pure Cotton
Dimension (L*W*H) : 40 cm x 35 cm x 10 cm
Color : White with Green Handles
Price 120.0 INR
Minimum Order Quantity : 60 Dozens
Product Type : Other
Material : Aluminum
Dimension (L*W*H) : 600x600