Split the Values by weekly with Condition

[velu130486]

Dear Seniors,

I would like to seek your help for solving my problem. I have created a Manning Plan by Monthly basis, Now I want to split the values by Weekly Basis as follows. My assumption is every month is having 4 Weeks averagely, so based on the value in months, it should return the results in weekly columns as follows

For Ex
M1 M2 M3
0.5 0.75 1

If the value is 0.5 then it should return the following results
WK1 WK2 WK3 WK4
0 0 0.25 0.25

If the value is 0.75 then it should return the following results
WK1 WK2 WK3 WK4
0 0.25 0.25 0.25

If the value is 1 then it should return the following results
WK1 WK2 WK3 WK4
0.25 0.25 0.25 0.25

If the value is less than 0.25 it should return the following results
WK1 WK2 WK3 WK4
0 0 0 0.25

Please help me to sort out this issue. Please let me know for any further calculations

Thanks and Regards
R. Vadivelan

 

[velu130486]

Thank you Wilson. It was quite helpful for me. I had managed to work with the previous formula.

Thanks and Regards
R. Vadivelan