This question was asked in Step 3 Use of Simple Formulas and Dragdown

i need  the answer of question no 2

VAT CALCULATION IN EXCEL

 

http://teachoo.com/693/213/Step-3-Use-of-Simple-Formulas-and-Dragdown/category/Basic-Excel/ 

Partha Dutta's image