How to get value through a matrix?

Xemx · #1 10-20-2014, 08:15 AM

The BOLD box needs to provide us with the combined result of the following;
- When inputting the scale level within the 'Sample Point' section (ie:K9 & K10), the formula will use both values to determine; the multiplication range highlighted in the Matrix for the number of ECTS (ie: Scale level 5 by 20 ECTS should; Multiply the first 10 ECTS by 30, and the second 10 ECTS by 15 for a total of 450).

How can we go about this?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a matrix of formulas	atis	Excel	3	05-30-2014 08:48 AM
making correlation matrix	Ridgerunner	Excel	3	03-22-2013 07:09 AM
Dot Matrix Printing	Angela	Office	2	05-15-2012 08:56 PM
Matrix Algebra	judicial85	Excel	3	10-12-2011 05:41 PM
From Outlook to Dot Matrix Printer	ihightower	Outlook	0	10-04-2010 09:15 AM