Let's say I have the following values in cells:
A B C D
1 0.1 | 0.5 | 0.3 | 2.1`
I am looking for the formula with which I can calculate without intermediate cells
(1 + 0.1) * (1 + 0.5) * (1 + 0.3) * (1 + 2.1)
What I've tried was (without success):
PRODUCT(1 + A1:D1)
{}
around the formula.