Ich würde gerne folgende Formel kürzen. Hat jemand Ideen?
Danke
Günter
=('planting stock'!G5*factors!R5+'planting stock'!H5*factors!R5+'planting stock'!I5*factors!R5+'planting stock'!J5*factors!R5+'planting stock'!K5*factors!R5+'planting stock'!L5*factors!R5+'planting stock'!M5*factors!R5+'planting stock'!N5*factors!R5+'planting stock'!O5*factors!R5+'planting stock'!P5*factors!R5+'planting stock'!Q5*factors!R5+'planting stock'!R5*factors!R5+'planting stock'!S5*factors!R5+'planting stock'!T5*factors!R5+'planting stock'!U5*factors!R5+'planting stock'!V5*factors!R5+'planting stock'!W5*factors!R5+'planting stock'!X5*factors!R5+'planting stock'!Y5*factors!R5+'planting stock'!Z5*factors!R5+'planting stock'!AA5*factors!R5+'planting stock'!AB5*factors!R5+'planting stock'!AC5*factors!R5+'planting stock'!AD5*factors!Q5+'planting stock'!AE5*factors!M5+'planting stock'!AF5*factors!M5+'planting stock'!AH5*factors!M5) /1000