PRODUCT Command
"Claus Busch" wrote in message ...
Hi Rick,
Am Fri, 7 Sep 2018 09:53:43 -0400 schrieb Rick:
I thought I understood how to use the PRODUCT command until I saw this
formula:
{=PRODUCT(D61:D76+1)-1
I know that =PRODUCT(D61:D76) would multiply the entries in cells D61
through D76 together, but what does that +1 do that is next to the last
entry in the range?
this works only as array formula. It adds 1 to each value in the range.
Regards
Claus B.
Thanks!
--
|