Microsoft Excel 2007 AVE (Average) function not working

Asked By 0 points N/A Posted on -
qa-featured

Microsoft Excel 2007 AVE (Average) function not working.

I am new in Windows 2007. I previously worked on Lotus 123 and Quattro.

I know that Microsoft Excel and Lotus 123 and Quattro are the same in function.

Why can I not get the exact result when I am getting the average function in Excel 2007?

I got the result #NAME?

What does it mean?

This is the formula: D11 = AVE(D1:D10)

SHARE
Best Answer by Montery Wilson
Answered By 0 points N/A #81592

Microsoft Excel 2007 AVE (Average) function not working

qa-featured

In MS Excel, the correct formula is  =Average(D1:D10)

Try it.

Best Answer
Best Answer
Answered By 0 points N/A #81593

Microsoft Excel 2007 AVE (Average) function not working

qa-featured

Microsoft Excel 2007 versus Lotus 123 and Quattro average function

I'm not really sure if Lotus 123 and Quattro are still in use today. Yes it is true that Lotus 123 and Quattro have the same function with Microsoft Excel 2007 because they are what we call the electronic spreadsheet.

But off course there are changes as the software innovation is concerned. First of these, the forms or windows are too far from the old Lotus 123 and Quattro system. We are in the GUI (Graphical User Interface) today not on the old system which is called the TBI or the Text Based Interface.

By the way, Microsoft Office Excel has been always integrating the slash (“/”) command in the Lotus 123 environment. You can use the “Slash/Data/Sort” command in Lotus 123. To do the command I have mentioned in Excel, just press the Slash key (“/”) then press the first letter of the command (like for instance Data – press “D”). The “Slash/Data/Sort” should be “/DS”.

The AVE function in Lotus 123 is equivalent to AVERAGE function in Excel. Instead of the formula AVE(D1:D10) use AVERAGE(D1:D10).

That function is commonly mistaken by some Lotus 123 and Quattro users.

Answered By 0 points N/A #81594

Microsoft Excel 2007 AVE (Average) function not working

qa-featured

It seems that you have used an inconsistent function in MS Excel. If you want to get the average of a data range:

  • Get into the cell where you want the average value.
  • Click on Home tab.
  • Click the down arrow in Sum tool in Editing group. You can see some simple functions in Excel.
  • Select Average from there. Now you have to specify the range of cells where those data are in.
  • Just type the first cell name in the range. Then type a colon. Then the last cell name of the range.
  • Your function looks like =Average(A1:A10)
  • Press the Enter key. You will get the answer.

Login/Register to Answer

Related Questions