A
alexzagrant
HI,
I am looking to simplify a HUGE equation. I have a large list (A- BP
columns) x 300 rows. And the equation is a simple add multiply
equation, but it is just so large i get an error before I finish it.
The general equation goes like this:
=$AC19*Qty!$AG$2+$AD19*Qty!$AE$2
+$BH19*Qty!$AG$2+$AF19*Qty!$AG$2
+$AG19*Qty!$AG$2........+$BP19*Qty!$AG$2
Maybe a function? or a If statement? maybe some kind of loop thing? I
don't have a clue.
Any help would be appreciated.
Thanks,
A.
I am looking to simplify a HUGE equation. I have a large list (A- BP
columns) x 300 rows. And the equation is a simple add multiply
equation, but it is just so large i get an error before I finish it.
The general equation goes like this:
=$AC19*Qty!$AG$2+$AD19*Qty!$AE$2
+$BH19*Qty!$AG$2+$AF19*Qty!$AG$2
+$AG19*Qty!$AG$2........+$BP19*Qty!$AG$2
Maybe a function? or a If statement? maybe some kind of loop thing? I
don't have a clue.
Any help would be appreciated.
Thanks,
A.