PDA

View Full Version : Calculating An Average



Mattster2020
10-02-2009, 08:09 AM
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

Bob Phillips
10-02-2009, 09:01 AM
Try

=D5/(E5/60)