Automatically Distribute Values

Hello!

I am working on a template that I am currently using to automatically distribute the total number of points to the number of meetings.

Here are the steps:
1.The user will encode the total number of points that will be automatically distributed.
2. The user will encode the number of meetings.

As the user encodes the number of meetings, excel will automatically assign how many points will be allotted for each meetings (I already have a working formula for this). I need to modify this formula in such a way that I would like to automatically subtract 9 from the total number of points so that only the difference will be distributed for each meetings.

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread:]

I have already closed the initial thread - OP said they posted in the wrong forum, and re-posted here. OP also changed the title for the initial thread, so I used that same title here.

Apologies for any confusion.

Admin

I may be misunderstanding, however it would seem that the formula in D5 and down could be modified to read:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Still not sure that I understand, however if the request is to modify the formula to find the row containing the total number of meeting hours as well as the manually placed value for total points in column W, then try:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Thanks for the reply and sorry for not opening responding here lately...been busy in the office lately. Anyway, here's an image of what I want to do.
EDIT: The No. of Meetings (hours) are manually encoded too.

It seems that you want the values in D5:D8 replaced so that D10 displays 40.
I feel that can not be done.
1. When the 9 is manually placed in cell D8 it will erase the formula.
2. When I amend the formula for cells D5:D7 so that they include the difference between W10 and D10 in I get a circular reference.
Perhaps another contributor will have a suggestion.

Try pasting the following into cell D5 and then dragging the fill handle down to cell D7:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.