Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PRODUCT Command
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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(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. -- Windows10 Office 2016 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Product Code and Product Description setup | Excel Worksheet Functions | |||
I need a product key for my Trail product, 2007 Microsoft Office s | Setting up and Configuration of Excel | |||
Chose a product and update related product variables | Excel Programming | |||
Convert numbers to text (from product id # to name of product) | Excel Programming | |||
Vlookup code product and to copy commentary with photo of the product in vba | Excel Programming |