How to depict an Infinite Series in Excel

 1. How to depict summation of 1/(2^n)

Here we assume that n is from 1 to 100. So we write in the formula

=sum(1/2^row(1:100))