#1   Report Post  
Old September 7th 18, 02:53 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2018
Posts: 2
Default PRODUCT Command

I thought I understood how to use the PRODUCT command until I saw this
formula:

{=PRODUCT(D6176+1)-1

I know that =PRODUCT(D6176) 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?


  #2   Report Post  
Old September 7th 18, 04:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,619
Default PRODUCT Command

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(D6176+1)-1

I know that =PRODUCT(D6176) 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.
--
Windows10
Office 2016
  #3   Report Post  
Old September 7th 18, 05:56 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2018
Posts: 2
Default PRODUCT Command

"Claus Busch" wrote in message news

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(D6176+1)-1

I know that =PRODUCT(D6176) 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!

--


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Product Code and Product Description setup Nastyashman Excel Worksheet Functions 4 July 6th 09 05:48 PM
I need a product key for my Trail product, 2007 Microsoft Office s sltchsyi Setting up and Configuration of Excel 0 May 4th 09 01:32 AM
Chose a product and update related product variables hupjack Excel Programming 0 April 9th 09 11:57 PM
Convert numbers to text (from product id # to name of product) [email protected] Excel Programming 1 September 12th 07 09:58 PM
Vlookup code product and to copy commentary with photo of the product in vba [email protected] Excel Programming 0 October 2nd 06 03:54 AM


All times are GMT +1. The time now is 07:39 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017