• 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.

automatically divide target value in rest working days

Ghazala

New Member
Hi thank you for very helpful all videos.
i need you your help.
i have 50000 target for month.
i want to divide it in working days.
as some one completed 4000 by 1day of month then again rest value divided in rest working days equally.
 

Attachments

  • Mandeep_sir (1).xlsx
    6.1 KB · Views: 4
i have 50000 target for month.
i want to divide it in working days.
as some one completed 4000 by 1day of month then again rest value divided in rest working days equally.
Maybe you are looking for something like this?
77572

Code:
= IF(ISBLANK(actual),
    (target - SUM(actual)) /
        (ROWS(actual) - COUNTA(actual)),
    actual)
 

Attachments

  • Mandeep_sir (1).xlsx
    10.7 KB · Views: 3
Back
Top