Planning and Forecasting Tool.

[Blake 7]

Dear Community, I am appealing for help.

I am not sure of the function name which will help me hence the Wooley Tittle!

Attached is a planning and forecasting tool, its aim is to allow the “user” to plan income generated by students (I work in a college)!.

Cells AN10:AR22 are dedicated to "withdrawal scenarios" e.g. what would the effect on revenue be if a % of students left the course

I would like to be able to enter a % figure in AP11 which the gives the student equivalent in AQ11 and a revised income figure in AR11. I am not sure how this could be done.

FYI DonkeyOTE is the man behind the clever code! C11:AL22 I will not take credit!

Thank you for reading this post.

Darren Chapman