| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#value! on spreadsheet when formula palette gets correct result
=AVERAGE(IF(C5:C14="Europe",D5:D14)), an example in the help, gives correct
result within the palette formula editor, but the #value! is all that shows up in the spreadsheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#value! on spreadsheet when formula palette gets correct result
do you enter as an array (control + shift + enter)?
"wingham" wrote: =AVERAGE(IF(C5:C14="Europe",D5:D14)), an example in the help, gives correct result within the palette formula editor, but the #value! is all that shows up in the spreadsheet. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#value! on spreadsheet when formula palette gets correct resul
Thanks - it works now like it is supposed to! Thanks again
"duane" wrote: do you enter as an array (control + shift + enter)? "wingham" wrote: =AVERAGE(IF(C5:C14="Europe",D5:D14)), an example in the help, gives correct result within the palette formula editor, but the #value! is all that shows up in the spreadsheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use spellnumber formula | Excel Worksheet Functions | |||
| Currency to Text | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Linear Mode
