Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extra comma at the end of a function
I have the following simple funtion in a spreadsheet and noticed that it did
not produce the anticipated result when checking my numbers: =AVERAGE('specimen data'!B5,'specimen data'!B11,'specimen data'!B17,'specimen data'!B23,'specimen data'!B29,'specimen data'!B35,'specimen data'!B41,) The comma after the B41 cell seems to produce a different answer than anticipated and correct answer is produced when the comma is removed: =AVERAGE('specimen data'!B5,'specimen data'!B11,'specimen data'!B17,'specimen data'!B23,'specimen data'!B29,'specimen data'!B35,'specimen data'!B41) How is the last comma in the first function affecting the calculation? Is it including other cells, or is it ignoring cells in the function? Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
extra results in the MAX function | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |