A | B | C | D | E | F | G | H | I | |
3 | 250 | 500 | 750 | 1000 | 1250 | 1500 | |||
4 | Numerator | Denominator | Decimal | 1 | 2 | 3 | 4 | 5 | 6 |
5 | 1 | 1 | 1 | 250 | 500 | 750 | 1000 | 1250 | 1500 |
6 | 2 | 1 | 2 | 500 | 1000 | 1500 | 2000 | 2500 | 3000 |
7 | 3 | 2 | 1.5 | 375 | 750 | 1125 | 1500 | 1875 | 2250 |
8 | 4 | 3 | 1.333333333 | 333.3333333 | 666.6666667 | 1000 | 1333.333333 | 1666.666667 | 2000 |
9 | 5 | 3 | 1.666666667 | 416.6666667 | 833.3333333 | 1250 | 1666.666667 | 2083.333333 | 2500 |
10 | 5 | 4 | 1.25 | 312.5 | 625 | 937.5 | 1250 | 1562.5 | 1875 |
11 | 6 | 5 | 1.2 | 300 | 600 | 900 | 1200 | 1500 | 1800 |
I need to perform some complex equations which may require VBA, based on the above table.
If the formula below is called Formula1:
=EXP(-3.51*(0.24/((0.0207*MIN(D5:D$6))+18.96))*(MAX(D5:D$6)-MIN(D5:D$6)))-EXP(-5.75*(0.24/((0.0207*MIN(D5:D$6))+18.96))*(MAX(D5:D$6)-MIN(D5:D$6)))
And if Formula2 is exactly the same, but with different cell references, ditto Formula 3, then the complete formula will look like this:
=Formula1+Formula2+Formula3, etc.... +FormulaX+FormulaY+FormulaZ
If I wasn't using VBA, all this would need to be placed in a single cell.
We can see Formula1 references D5 and D6.
Formula2 would reference D5 and D7
Formula3 would reference D5 and D8
...all the way down to the end of the table. Then across:
FormulaX would reference D5 and E6
FormulaY would reference D5 and E7
FormulaZ would reference D5 and E8
...all the way across to the end of the table.
All that would be in a single cell, which means many additions.
For the next cell down:
Formula1 would reference E6 and E5
Formula2 would reference E6 and E7
Formula3 would reference E6 and E8
...all the way down. And:
FormulaX would reference E6 and D5
FormulaY would reference E6 and D7
...all the way across.
In other words, in each cell I place the formula, it would need to reference every cell in the table from D5:I11. And the total number of cells I placed the formula in would equal the number of cells in the table D5:I11, which is 42.
In order for this not to be very tedious, I'm wondering if there is a faster solution than entering all that data one cell at a time. Such as VBA?
If you are familiar with the languages MATLAB, C, or LISP, the code for those programs are given here: computer programs
You may be able to use the information there for an Excel VBA translation (although my above formula above does not take into account amplication, whereas the programs at the given link do).
Any advice on this is much appreciated!
Note: The solution does not have to be VBA.