Results 1 to 5 of 5

Returning Blank fields

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    22

    Returning Blank fields

    Hi, I've created a very simple description template of what I'm trying achieve. The number sold looks up from the sales team Total for a quarter & then column F works out the stock sold as a % of the total stock held. What I need to work out is how do I get fields that have no data in them Q3 & Q4 to return a blank field so that the total % F9 isn't calculating the result by dividing the toal by 4 when there is only 2 quarters of data. (I hope that makes sense)
    Attached Files Attached Files
    Last edited by mgmerv; 06-24-2015 at 11:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 11-21-2014, 10:00 PM
  2. [SOLVED] Blank cells not returning a blank value...
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2014, 11:01 AM
  3. [SOLVED] Returning most recent dates with conditions where some fields are blank
    By connmtc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 06:06 PM
  4. Replies: 2
    Last Post: 06-21-2012, 04:51 PM
  5. vlookup returning blank for blank instead of 0
    By krayziez in forum Excel General
    Replies: 4
    Last Post: 07-31-2008, 11:58 AM

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