topic Re: how to calculate amount based on discount% in App Development

how to calculate amount based on discount%

panipat1990 — Sat, 16 Nov 2024 19:38:24 GMT

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.

aworrall — Sun, 24 Nov 2019 23:00:07 GMT

I’m not sure I understand 100% but could you not do this with a nested IF statement. It looks to be similar to a threshold based discount calculation

panipat1990 — Wed, 27 Nov 2019 07:36:41 GMT

Kindly send me one qvd maker.where I understand.how to calculate