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. – Scott Craner Nov 18 '16 at 14:31