• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Qurat

New Member
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
 

Attachments

  • Formula Making2.xlsx
    29.6 KB · Views: 5
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
 
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.
 
Back
Top