+ Reply to Thread
Results 1 to 2 of 2

Formula result correct, but shows up incorrectly in cell

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Cincinnati, OH
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Formula result correct, but shows up incorrectly in cell

    I've entered the following formula in Excel 2007

    =QUARTILE(IF('Valid Alerts'!$C$5:$C$1384=C$162,'Valid Alerts'!$L$5:$L$1384,""),'Box & Whisker Plots'!$B163)

    If I click the Fx by the text bar at the top of the screen, it shows the correct value of 20.5.
    function arguments.JPG

    But on the worksheet, it shows a value of 3.6 (not sure where that comes from!)
    Excel cell.JPG

    All cells containing this formula are incorrect. In the attached file, the yellow cell is the one I'm talking about. But all other cells in that column are an incorrect value. And the next column is the exact same formula and again the formula results is correct when I click Fx, but it shows #VALUE! in the cells

    I've tried Ctrl+Shift+Enter but it doesn't work. I've seen other posts online about the formula showing up instead of value (easily fixed), but none about the wrong value showing up

    Thanks for your help!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,743

    Re: Formula result correct, but shows up incorrectly in cell

    Hi
    I thought of answering with a picture, but that would be as useless as the picture you posted. Please post a sample wbk.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1