| 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? |
| 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 | |||
![Rick[_40_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
