Forum Discussion
Calculations using a table
I have a spreadsheet that has 5 "courses", I need to calculate "revenue" based on percentage completed (weeks completed/total weeks). I have one table with student data including course name, weeks completed and total tuition amount. I have a second table with the % complete that triggers a specific % of revenue to recognize. I have a third table that has the % to recognize upon the triggering % from table #2.
Now what? Does anyone have a recommendation on how to make the tables talk to each other to give me the needed calculation?
1 Reply
you can use match, index, offset formulas to find whichever data you need from any row and any column.
