how to calculate amount based on discount %

[panipat1990]

Dear Team,

Hope you are doing well!!!!!!!!

i Stuck a Requirement. i am calculating amount based on discount% as per given in excel.My Amount is 900000.

i want to calculate amount based on slab no.1,Slab no.2 And Slab no.3.

Means

0-300000                             discount 35%               300000*.35=105000

300000-500000                 discount 30%              100000*.30=30000

500000-1000000                discount 25%             500000*.25=125000

900000 lakh divided in three slabs.i am giving excel according to slab wise.kindly attached the excel.