Hi Please help Me out for the Making Excel Formula !!

[Qurat]

Please help me out for formula making !!

if BG2-B5 complete full quarter earn so apply percentage 3% (i.e. BI13), then BH2-B5 complete fully 2 quarter so apply 9% (i.e. BJ12) and so one till 3%(i.e. Bp13)

Similarly, in second case if BG2-B7 complete 1 month only so i can't apply percentage 3% (i.e. BI13) because 3% is the fully earn quarter so what would be the formula for 1 month earn show in 1st lag and remaining would be show in the 8th quarter, and the remaining quarters are same as above paragraph.

Red Highlighted is the main confusing for me !!

Attached file is for the reference !!

Thanks in advance
Regards
Qurat

 

[pecoflyer]

Duplicate https://chandoo.org/forum/threads/i-want-to-create-the-excel-formula-please-help.45565/

 

[Qurat]

Hi pecoflyer.

Hope you are good.

I posted in two different way, hope this is the clear picture for creating the formula.

Please help me out if if you want !!

thanks

 

[Luke M]

I've closed the other thread, since this one contains further detail.

 

[Qurat]

Please help me out to solve my problem !!

Thanks

 

[pecoflyer]

Patience my friend. This is a free forum were members help on their spare time. If you need fast answers there are pay aid sites that will surely be willing to help.