+ Reply to Thread
Results 1 to 4 of 4

Formula doesn't work correctly

  1. #1
    Forum Contributor
    Join Date
    01-06-2015
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    185

    Formula doesn't work correctly

    =IF(A2="","",SUM(C$2:C$20000))/12

    The problem I have is cell A2 will not have anything there, but I get a #VALUE! result. If A2 actually has data, then it shows the result. Can someone tell me how to make my cell that this formula is located in return back blank if A2 is blank. Thanks,

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formula doesn't work correctly

    Do the /12 on the result of the SUM, not on the result of the IF.

    When your IF condition is FALSE, then IF returns ""
    ""/12 = #Value!

    Try
    =IF(A2="","",SUM(C$2:C$20000)/12)

  3. #3
    Forum Contributor
    Join Date
    01-06-2015
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    185

    Re: Formula doesn't work correctly

    You're a Genius!!! Thanks a ton

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formula doesn't work correctly

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-17-2015, 09:06 AM
  2. [SOLVED] Lookup function doesn't work correctly?
    By csleong in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2014, 03:52 AM
  3. Read clipboard doesn't work correctly
    By marmotinchen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2011, 08:16 AM
  4. Excel 2007 : Ctrl v doesn't work correctly
    By risman in forum Excel General
    Replies: 2
    Last Post: 02-28-2010, 11:53 AM
  5. Help Please. Trying to get this formula to work out correctly.
    By bryanr72 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2008, 10:43 PM
  6. [SOLVED] Sorting numbers doesn't work correctly
    By GrammyEmmy in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-25-2006, 06:50 PM
  7. Function doesn't work correctly with protection on
    By BigDave in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-15-2005, 03:24 PM

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