| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AVERAGE function
I typed the formula =AVERAGE(P8:P107) and the program returned a hypen -
where the result was supposed to go. Yet when I clicked on the fx formula bar, the poput window came up and showed the correct result. Why doesn't it show up on my spreadsheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGE function
Try widening the column, and also reformatting the cell to general formatting -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=555305 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Function (include Blank Cells and Zeros) | Excel Discussion (Misc queries) | |||
| Figuring daily average...function ??? | Excel Worksheet Functions | |||
| AVERAGE function returns #DIV/0! error | Excel Discussion (Misc queries) | |||
| Average function assistance | Excel Discussion (Misc queries) | |||
| Using the average function | Excel Worksheet Functions | |||
Hybrid Mode
