Hey all,
Spreadsheet has one input for the time being - revenue.
There are 2 outputs - DBE Profit and Traditional Profit.
I want excel to record the vales for DBE Profit and Traditional Profit as I change the value for revenue.
So when I change revenue to X, I want the corresponding values of DBE Profit and Traditional Profit (which are determined by X) to be recorded in a table.
How would I achieve this?
Have attached a picture of the spreadhseet for clarification.
Cheers.
Solved! Thanks to this YouTube video: http://www.youtube.com/watch?v=kfznvWGzt0Y
Bookmarks