How does one do product notation in Microsoft Excel?

Question

berrymox · Answer

For example:

berrymox · Answer

$$\prod_{n=500}^{1200}0.005n+1.14$$

berrymox · Answer

@mathstudent55

dumbcow · Answer

Excel should have a product function built in....
=Product(A1,B1,C1...)

berrymox · Answer

But wouldn't that just be Prouduct of n=a1 to whatever of n ?

berrymox · Answer

How would I make it of 0.005n+1.14 ?

dumbcow · Answer

hmm it wont let me attach a file

berrymox · Answer

take a print screen and upload it? idk

dumbcow · Answer

anyway, make a column for the "N" values, 500 to 1200
Then in next column, write ".005*An +1.14"
In 3rd column, use product function.... product(B2:B)

berrymox · Answer

Do I need to make one cell for every number from 500 to 1200, or just thoe two?

berrymox · Answer

I'm working with large numbers, so...

dumbcow · Answer

no you need a cell for every number between 500 and 1200

dumbcow · Answer

fyi, for this example the answer is going to be a very very large number

berrymox · Answer

Makes me wish it had a closed form for n > 1

berrymox · Answer

Of course it's large, it's a product notation