Consulting

Results 1 to 2 of 2

Thread: Calculating An Average

  1. #1

    Calculating An Average

    Afternoon,

    Here goes,I need to work out an average based on the contents of cells D5 = 300 & E5 = 360. Straight forward formula D5/E5,the easy part.

    But..... Is there a way to first divid E5 by 60, then divind the result of that by D5 all within the same formula?

    Any help would be appriecated.

    Regards,

    Matt

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try

    =D5/(E5/60)
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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