AVERAGE function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try widening the column, and also reformatting the cell to general
formatting
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average exluding max and min values 11
Concatenating two text strings, formula is right, cell output is w 3
Average Function 2
Average formula works but.... 3
UDF Function 1
countifs Function not giving desired result with date criteria 2
Average formula only works partially..... 6
how to scroll while in formula bar (Excel 2007) 0

Back
Top