Allocate money across workdays to the exact amount

[andrew007uk]

I want to be able to allocate cash across work days, that takes account or rounding. I have created the following worksheet and it works, but i cannot work out how to allocate the sums and take account of roundings to reach an exact number.


-- removed inline image ---

 

[jorismoerings]

Hi, Welcome to the board.

Tricky question with this little information to go on.
You state having created the following worksheet but i'm not seeing any sample data or .....

Some deeper elaboration on what you expect as a result will also help.

 

[andrew007uk]

This is what i have created


-- removed inline image ---

 

[jorismoerings]

Hi,

Still not seeing anything on Explorer, Firefox or Chrome.
Take a look at forum tips (spec B2) on how to copy samples form excel sheets to the forum.
http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

 

[andrew007uk]

Maybe this will work... sorry, i am new to this


https://onedrive.live.com/redir?resid=B5CA44AAF0DFFEBB!76038&authkey=!AE9Sb6c13WuCnlU&ithint=folder,