Average Function

A

angy345

Hi ! does anyone know why when i use the AVERAGE Function on an excel
column that contains text,blanks and numbers i get something like
1.28102E+49 as answer.

Help would be very much appreciated..thanks in advance.

Angel
 
K

Kevin Stecyk

Angel,

We would have to see your entire column of data to better understand what
AVERAGE is doing, and why the answer is not what you expect.

Regards,
Kevin
 
J

Joe

The cell is in Scientific format.
Right click the cell, pick Format Cells..., pick the
Number tab, pick Number.
 

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

Cell data entering slow! 0
countifs Function not giving desired result with date criteria 2
AverageIf function with multiple columns 1
averaging multiple items from one list 2
Trying to find additional ranges outside of min, max, and average 2
Using the IF and IFBLANK functions 3
Need help with average/lookup formula 2
Average with criteria for adjacent cells ? 1

Top