Comments on: Mean, median and mode in Excel

When analyzing numerical data, you may often be looking for some way to find the "typical" value. For this purpose, you can use one of the so-called measures of central tendency such as arithmetic mean, median or mode. Continue reading →

Table of contents

Comments page 2. Total comments: 36

  1. hello dear,

    just I wanna want if we can use the mode and median for text?

  2. Could subtotal work with countif function ??

    I want the formula auto update when I filtered the category,

    Regard,

  3. =5487564/100000 answer 54.87564
    i want above formula only 54.88

    1. Hi Jshekar,

      You can display fewer decimal places by clicking the Decrease Decimal icon on the ribbon (Home tab > Number group) or setting up the custom number format to show only 2 decimal places.

      Alternatively, you can use the ROUND function:

      =ROUND(5487564/100000,2)

  4. Svetlana, lot of thanks.

      1. Hi How do I calculate the next due service date for the truck which uses hours for its operations.using Excel Formular for example
        The last service was done :
        Last service date :26.05.2015
        Service interval :250hrs/month
        Minimum hrs:9.5hrs/day
        Next service due date :?
        How do I calculate using Excel Formular... Due

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)