EXCEL - MED function

Discussion in 'Software' started by tomribeiropereira, Mar 2, 2011.

  1. tomribeiropereira

    tomribeiropereira

    Joined:
    Mar 2, 2011
    Messages:
    1
    Hi, hope you can help me with a questions.

    I have five number in five cells. I have to calculate the median of them like 3,5,6,8 and 10 and the result of this should be 6, right.

    But sometimes on of those numbers are unknown and i just put (0) instead of it like 3,5,0,0,10 and the result is 3, right.

    But the result should be 5 because 0,0 are not numbers in fact.

    So, i need that the function MED skip the 0 number.

    Is that possible? Thank you much for your atention.:adore:
    tomribeiropereira, Mar 2, 2011
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Adam Landas

    BGP Med quesion

    Adam Landas, Mar 23, 2005, in forum: Cisco
    Replies:
    4
    Views:
    3,052
    Ivan Ostreš
    Mar 25, 2005
  2. Erik Sørvold

    Problem med Internet Explorer

    Erik Sørvold, Jan 14, 2004, in forum: Computer Support
    Replies:
    5
    Views:
    750
    Rob K
    Jan 15, 2004
  3. Spunky
    Replies:
    1
    Views:
    520
    LO&MsLO
    Jan 15, 2004
  4. joevan
    Replies:
    2
    Views:
    427
    joevan
    Feb 23, 2004
  5. Greystars Services Pvt. LTd- online Examination fo

    SELF ASSESSMENT SCHEME - ONLINE PRACTICE EXAMS - FOR ENGG. & MED. ASPIRANTS

    Greystars Services Pvt. LTd- online Examination fo, Apr 30, 2004, in forum: Computer Support
    Replies:
    1
    Views:
    520
    =?UTF-8?B?UGFsaW5kcuKYu21l?=
    Apr 30, 2004
Loading...

Share This Page