Results 1 to 11 of 11
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    average vs. avg (2003)

    Silly question of the day:
    Why does Excel have max and min functions but no avg?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: average vs. avg (2003)

    The AVERAGE worksheet function is the equivalent of what is called AVG in some other applications.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: average vs. avg (2003)

    understood, but my question was more to why maximum and minimum were abbreviated for the function name and average was not. Did Lotus copyright the @avg?

    I finally set up autocorrect to have avg give me =average( as I continually transpose letters when I type....

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: average vs. avg (2003)

    You'd have to ask Microsoft. My guess would be that they thought AVERAGE was more user-friendly (for unexperienced users) than AVG. I don't think there is a copyright on AVG. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: average vs. avg (2003)

    John

    Average is the least of my problems......How about CONCATENATE? I hate it <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  6. #6
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: average vs. avg (2003)

    fortunately, that is one that I use rarely

    try the autocorrect trick; e.g., conc will give you =concatenate when you enter the (

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: average vs. avg (2003)

    I was smiling at your top tip, thanks, I LOVE top tips and this is a very good one. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Jerry

  8. #8
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: average vs. avg (2003)

    of course, why be a piker?

    instead of conc use c

    <g>

  9. #9
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: average vs. avg (2003)

    ....'cos while I have sat here I have:

    conc=Concatenate(
    co=Count(
    coa=CountA(
    cob=CountBlank(
    coi=CountIf(


    <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  10. #10
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: average vs. avg (2003)

    I'd rather use/say "catenate" than "concatenate"

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: average vs. avg (2003)

    I'd simply say : =JOIN()... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •